Inventory search by other fields?

[Mike.Sheen]

Interesting thing is the Auto Query doesn't error it just ignores anything it doesn't understand

That's the nature of modern deserialisers - if a field is present in the json that is not in the poco backing it, then it is silently ignored.

[oliverbrooke]

Thanks for the replies and attention all, very much appreciated.
I will admit to being somewhat confused still though.

I get some sort of data with the following cURL request but I'm not convinced it's legit because AFAIK there should only be one match for this Aux5 value;

$ch = curl_init('https://api.CLIENTDOMAIN.com.au/Queries/InventoryItemList?Aux5Contains='.$_GET["search"].'&Fields=InventoryID,PartNo,Description,Aux5&include=Total&apikey=CLIENTKEY');

I don't necessarily need to see the Aux5 returned in the results but it seems like it would be helpful to be able to confirm...
I'm fairly sure this isn't doing what I want but I'd LOVE if anyone knew how to get this to return the details of the matching inventory item...?
Possible?

[Mike.Sheen]

Thanks for the replies and attention all, very much appreciated.
I will admit to being somewhat confused still though.

I get some sort of data with the following cURL request but I'm not convinced it's legit because AFAIK there should only be one match for this Aux5 value;

$ch = curl_init('https://api.CLIENTDOMAIN.com.au/Queries/InventoryItemList?Aux5Contains='.$_GET["search"].'&Fields=InventoryID,PartNo,Description,Aux5&include=Total&apikey=CLIENTKEY');

I don't necessarily need to see the Aux5 returned in the results but it seems like it would be helpful to be able to confirm...
I'm fairly sure this isn't doing what I want but I'd LOVE if anyone knew how to get this to return the details of the matching inventory item...?
Possible?

You can't use InventoryItemList as it does not have the field Aux5, and as such the Aux5Contains would just be ignored.

Try this:

Code: Select all

$ch = curl_init('https://api.CLIENTDOMAIN.com.au/Queries/IN_Main?Aux5Contains='.$_GET["search"].'&Fields=InventoryID,PartNo,Description,Aux5&include=Total&apikey=CLIENTKEY');

[oliverbrooke]

Thank you Mike - that worked perfectly!!