# Orders v3 endpoint, retrieve orders for multiple suppliers?

**URL:** <https://forums.ordoro.com/t/orders-v3-endpoint-retrieve-orders-for-multiple-suppliers/717>\
**Category:** Uncategorized\
**Created:** [May 5, 2021, 1:33pm UTC](https://forums.ordoro.com/t/orders-v3-endpoint-retrieve-orders-for-multiple-suppliers/717 "2021-05-05T13:33:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dma550](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@dma550](https://forums.ordoro.com/u/dma550)\
**Post date:** [May 5, 2021, 1:33pm UTC](https://forums.ordoro.com/t/orders-v3-endpoint-retrieve-orders-for-multiple-suppliers/717/1 "2021-05-05T13:33:46Z")

</div>

Hi, so I see that the endpoint reports that the supplier parameter is an array:

 ![image](https://canada1.discourse-cdn.com/flex029/uploads/ordoro/original/1X/8cf872944d83441d28f6167fd5cc8fe7d13b5ae6.png)

I tried comma separated and I get a SQL error in my response.

```
"error_message": "(psycopg2.DataError) invalid input syntax for integer: \"52613,52364\"\nLINE 3: ...true AND shipping_dropshipinfo.dropshipper_id IN ('52613,523...\n ^\n [SQL: 'SELECT orders_order.order_id AS orders_order_order_id, count(*) OVER () AS full_count \\nFROM orders_order JOIN shipping_shipment ON orders_order.id = shipping_shipment.order_id LEFT OUTER JOIN shipping_dropshipinfo ON shipping_shipment.id = shipping_dropshipinfo.shipment_id \\nWHERE orders_order.company_id = %(company_id_1)s AND orders_order.v3_status IS NOT NULL AND orders_order.is_order_parent = false AND orders_order.ready = true AND shipping_dropshipinfo.dropshipper_id IN (%(dropshipper_id_1)s) ORDER BY orders_order.created DESC NULLS LAST \\n LIMIT %(param_1)s OFFSET %(param_2)s'] [parameters: {'company_id_1': 572172, 'dropshipper_id_1': '52613,52364', 'param_1': 10, 'param_2': 0}]",
"param": null

```

}

Then for curiosity I researched different means of passing array parameters in a query string. It seems that something like this is a convention, though I have rarely used it - it involves duplicating the QS parameter.

[https://apiverson.ordoro.com/order?supplier=52613&supplier=52364](https://apiverson.ordoro.com/order?supplier=52613&supplier=52364)

It seems to work but I want to confirm this is proper for your parameters listed as array. Thanks

---

<div class="post-metadata">

**Author:** ![syork](https://yyz1.discourse-cdn.com/flex029/user_avatar/forums.ordoro.com/syork/32/61_2.png) [@syork](https://forums.ordoro.com/u/syork)\
**Post date:** [May 5, 2021, 2:09pm UTC](https://forums.ordoro.com/t/orders-v3-endpoint-retrieve-orders-for-multiple-suppliers/717/2 "2021-05-05T14:09:23Z")

</div>

Yes, that is correct. Repeat the param for each item you wish to filter by.