Find a api to get a salesorder by using invoice no

[SBarnes]

It concerns me deeply that you seem to be wanting to read ALL sales orders and credit notes in full - this will be a major performance issue.

I don't disagree with Mike, although we have tried to answer your specific questions it may be better if you explain what you are trying to achieve so we can offer some advice on a strategy on how to achieve the desired outcome that will work effectively.

[kranil7701]

Not sure what you mean by bills but credit notes would be

Code: Select all

https://api.jiwa.com.au/Queries/SO_Main?CreditNote=true&Include=Total&Fields=InvoiceID,CreditNote&apikey=9vjoF4M5-gYVBWjoFyW9nlQieB9FhxpJkAsRJznB_Ok&format=json


or

Code: Select all

https://api.jiwa.com.au/Queries/SalesOrderList?CreditNote=true&Include=Total&Fields=InvoiceID,CreditNote&apikey=9vjoF4M5-gYVBWjoFyW9nlQieB9FhxpJkAsRJznB_Ok&format=json


Which give

Code: Select all

{
    "Total": 7,
    "Results": [
        {
            "InvoiceID": "000000002400000002SF",
            "CreditNote": true
        },
        {
            "InvoiceID": "14CF9F98DCBD44ABB5C0",
            "CreditNote": true
        },
        {
            "InvoiceID": "274BFA583BE04BA6A137",
            "CreditNote": true
        },
        {
            "InvoiceID": "5714562EFAA24A1A9EDC",
            "CreditNote": true
        },
        {
            "InvoiceID": "86C37C974A3C4155A47A",
            "CreditNote": true
        },
        {
            "InvoiceID": "D6333A2B92A645A9BF30",
            "CreditNote": true
        },
        {
            "InvoiceID": "F1149BC9C9A24FD4A0B4",
            "CreditNote": true
        }
    ]
}


i want to filter this by current date is it possibale to make changes in api

[SBarnes]

You don't need to change the api the swagger ui documents all the parameters you can supply have a look at https://api.jiwa.com.au/swagger-ui/#!/Q ... erList_Get

[Mike.Sheen]

i want to filter this by current date is it possibale to make changes in api

To return only sales order credit notes (for instance) for a specific date, you can use the InvoiceInitDate={Date} parameter:

https://api.jiwa.com.au/Queries/SalesOr ... ormat=json

Or for a range use InvoiceInitDateBetween={From Date},{To Date}:

https://api.jiwa.com.au/Queries/SalesOr ... ormat=json

For after a date use InvoiceInitDateGreaterThan={Date}:

https://api.jiwa.com.au/Queries/SalesOr ... ormat=json

And for before a date use InvoiceInitDateLessThan={Date}:

https://api.jiwa.com.au/Queries/SalesOr ... ormat=json

The conventions for the parameter names to use, based on operation desired and field name are documented over on the ServiceStack AutoQuery docs