When viewing instructions for the filter parameter of the various searches, found here: https://support.infopluscommerce.com/support/solutions/articles/11000019247-how-to-get-shipments-with-the-infoplus-api I recognize the syntax only as MongoDB query syntax. 2 questions: 1) Is this indeed what you're using? So when constructing queries for this property, can I consult their documentation? If not, what are you using? 2) Can I simply assign my query as a URI-encoded parameter? Like, v2.0/orders?filter=orderId%20eq%20500
1: We are not using MongoDB query syntax, despite the apparent similarity. We are using a custom query parser, whose syntax is documented in the search queries section near the top of our API reference page here: http://developer.infopluscommerce.com/api/reference/v2.0/#search
2: I believe your HTTP syntax there is correct (with the %20 's) - but note, the field you're looking for on the orders endpoint would be orderNo, not orderId. So if you were using curl, a command line like this would work for you (to find order 500):
I also want to mention, if you know you're trying to get a single record by its primary key, such as an order by its orderNo, you could avoid the search?filter approach, and just use: GET /infoplus-wms/api/v2.0/order/500
Dylan Belcher
When viewing instructions for the filter parameter of the various searches, found here:
https://support.infopluscommerce.com/support/solutions/articles/11000019247-how-to-get-shipments-with-the-infoplus-api
I recognize the syntax only as MongoDB query syntax. 2 questions:
1) Is this indeed what you're using? So when constructing queries for this property, can I consult their documentation? If not, what are you using?
2) Can I simply assign my query as a URI-encoded parameter? Like, v2.0/orders?filter=orderId%20eq%20500
Yup to all of that. Thanks!
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstDarin Kelkhoff
Hi Dylan, thanks for reaching out,
1: We are not using MongoDB query syntax, despite the apparent similarity. We are using a custom query parser, whose syntax is documented in the search queries section near the top of our API reference page here: http://developer.infopluscommerce.com/api/reference/v2.0/#search
2: I believe your HTTP syntax there is correct (with the %20 's) - but note, the field you're looking for on the orders endpoint would be orderNo, not orderId. So if you were using curl, a command line like this would work for you (to find order 500):
curl -H API-Key:YOURKEY -H Content-Type:application/json "https://YOURDOMAIN.infopluswms.com/infoplus-wms/api/v2.0/order/search?filter=orderNo%20eq%20500"
I also want to mention, if you know you're trying to get a single record by its primary key, such as an order by its orderNo, you could avoid the search?filter approach, and just use: GET /infoplus-wms/api/v2.0/order/500
Let me know if you have any further questions.
Thanks.
Dylan Belcher
Yup to all of that. Thanks!
-
Welcome to the Infoplus API
-
Integrate with Infusionsoft orders
-
Custom FIelds - How To
-
Creating an order with the Java Client Library
-
Creating an Order
-
Billing script help
-
serviceTypeId for split orders causes updates to fail
-
Updating a processed/shipped order
-
Adding Non-ASCII characters for orders
See all 12 topics