Where statement in JSON Api document

[Anonymous]

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

[ImkeF]

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.

[Anonymous · Accepted solution]

thank you for this, unfortunately Nookal are not very good at sharing information as it could cost them additional revenue. I have managed a work around at this stage so appreciate the reply

Regards,

Lucas