In my earlier posts , part1 , part2 I have explained about the various options for Odata.
This is a short post on filter query.
See the below query
Select * from SalesTable
where SalesOrderNumber="SO-1500" and DataAreaid = 'USRT'
How do you pass this to the odata query
https://fourl/data/SalesOrderHeadersV2?cross-company=true&$filter=SalesOrderNumber eq '015601 ' and...
Continue Reading AnithaEswaran’s Article on their blog
Odata query options with D365FO – Multiple filter
In my earlier posts , part1 , part2 I have explained about the various options for Odata. This is a short post on filter query. See the below query Select * from SalesTable where SalesOrderNumber = ‘SO-1500’ and DataAreaid = ‘USRT’ How do you pass this to the odata query https://fourl/data/SalesOrderHeadersV2?cross-company=true&$filter=SalesOrderNumber eq ‘015601 ‘ and…
Blog Syndicated with AnithaEswaran’s Permission
More About This Author
Array
Finance & Operations25 July 2024Logic apps Standard – Parameterization
Finance & Operations24 July 2024Extracting Subfolder Details from Parent Directory using logic apps
Finance & Operations7 June 2024GA of D365F&O 10.0.40
Finance & Operations30 May 2024Webhook validation handshake failed – Azure Event Grid