I know from this source https://msdn.microsoft.com/en-us/library/hh169248(v=nav.90).aspx,
that i can filter data from my Odata-feed like this: localhost/.../Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Miami'
But how should the URL look, if i want to specify $format=json, too?
*This post is locked for comments
I got it. I have to use "&$" to combine two filters.
I can´t find a solution.
1 This works: localhost/.../Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Miami'
2 This works: localhost/.../Company('CRONUS International Ltd.')/Customer?$format=json
3 This doesn´t:localhost/.../Company('CRONUS International Ltd.')/Customer?$format=json$filter=City eq 'Miami'
4 This doesn´t:localhost/.../Company('CRONUS International Ltd.')/Customer?$filter=City eq 'Miami'$format=json
Error for 3 is: Unsupported media type requested.
Error for 4 is: Syntax error at position 80 in 'Order_Date gt datetime'2017-11-30' and Order_Date lt datetime'2018-01-01'$format=json'.
Does anybody have further ideas?
Thank you very much!
I´m afraid localhost/.../Company('CRONUS%20India%20Ltd.')/Myquery?$filter=Location_Code eq 'BLUE' & $format=json doesn´t work. I get a 401 error... mhm.
Hi Niels,
The URL should include the format=json to obtained a document.
In NAV 2016 environemtn the URL is : localhost/.../Company('CRONUS%20India%20Ltd.')/Custmers?$filter=Location_Code eq 'BLUE' & $format=json
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (