Hello,
I was trying to perform some oData filter on the ReceiptOptionalField2s collection but the return from Web APi is:
statusCode: 400
{
"error": {
"code": "InvalidParameters",
"message": {
"lang": "en-US",
"value": "The request parameters are invalid."
}
}
}
Here is a sample of the PoReceipts payload
{
"value": [
{
"ReceiptOptionalField2s": [
{
"ReceiptSequenceKey": 1789290,
"OptionalField": "BACC",
"Value": "BLABLA",
"ReceiptOptionalField2Type": "Text",
"TextValue": "BLABLA",
}
}
]
}
]
}
and here is the request
{{URL}}/{{VERSION}}/-/{{COMPANY}}/PO/POReceipts?$filter=ReceiptOptionalField2s/all(f:f/TextValue eq 'BLA')
{{URL}}/{{VERSION}}/-/{{COMPANY}}/PO/POReceipts?$filter=ReceiptOptionalField2s/all(f:f/TextValue eq 'BLA')
Does Sage support filter on collections via Web API?
Thanks
Tiago