Forum Discussion
Where statement in JSON Api document
Hi,
I am attempting to query Nookal API for some work and am struggling with the ability to write a where function. below is the connection being used but want to say where invoice_id is not null or could say where invoice_id >=1
let
Source = Json.Document(Web.Contents("https://api.nookal.com/production/v2/getinvoices?api_key=Myapikey"))
in
Source
2 Replies
Hi Anonymous
This will be specified in the API documentation at nookals. Usually you just have to add some strings in the header/URL. But you have to follow the syntax specified in their API documentation.
