Format of JSON string when sending to API for filtering on a MISC field.

When doing an GetItem API call, I am trying to filter on the Misc06 field.

Specifically, I need to filter my dataset return to (Misc06 > 0)

My current string is

{"Filter":{"IsActive":"True","Misc06":">0","OutputSelector":["Name","RRP","Misc06","Misc11","store_price","ItemURL","Brand","Model","ShortDescription","Description","Specifications"]}}

I am getting the full database set, the Misc06 filter is being ignored.

Find more posts tagged with

Integrations

Accepted answers

All comments

Erik Merkley

The Neto API doesn't support comparisons. Filters are exact match only.

Also Misc06 isn't available as a filter for GetItem. Are you using the official docs? All the possible fields for filtering and output are listed here:

https://developers.maropost.com/documentation/engineers/api-documentation/products/getitem

Tony Freeman

So, do I have to loop thru a few thousand records just to find the 50 or so records that I actually want , because oData queries are not accepted ... that is one degree away from being useless.

Erik Merkley

Unless there's another field you can filter on to reduce the number of results... yep. If it's only a few thousand products it won't be a problem, the Neto API will deliver a large number of results quickly.

As an alternative, consider whether a scheduled export would work. Neto has an extremely powerful export system and you can definitely write B@SE to filter on miscellaneous fields. These exports can output any text format to email, FTP or a HTTP endpoint. They can't be run on demand though, it would have to be scheduled.