Invoice List

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areainvoices.json
GeneralYesParameters described in overviewuser=user&password=userStructure of an API call
Model StructureYesName of model requiredmodelstructure=invoiceslistUsing data models
ViewNoStored filter appliedUsing views
SortNoChange the view's default sort ordersort=CLIENTSorting
FiltersNoFilter by a key fieldFilters
CompanyYesThe company numbercompany=1

Example request:

http://<SERVER>/jsonapi/invoices.json?user=user&password=user&version=4&company=1&modelstructure=invoiceslist&client=1/F001

Example response:

"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 36,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"synapiversion": 3.8,
"data": [
  {
    "invoiceUuid": "D7B15EC4DFC34C95B60726D4935094B0",
    "invoiceTimestampModified": 1600842322,
    "invoiceRecordVersionNumber": 40,
    "invoiceNumber": "09",
    "invoiceDate": "2002-07-18",
    "invoiceClientJobOrPhase": "1/00000633.001",
    "invoiceType": "Iv",
    "invoiceDraft": false,
    "invoiceOrderNumber": "",
    "invoiceClientCode": "1/F001",
    "invoiceBillToClientName": "Ford Motor Cars",
    "invoiceClientName": "Ford Motor Cars",
    "invoiceBillToClient": "1/F001",
    "invoiceTotalNet": 30,
    "invoiceTotalSalesTax": 5.25,
    "invoiceCurrencyValue": 0,
    "invoiceCurrencyVAT": 0,
    "invoiceCurrencyCode": "",
    "invoiceExchangeRate": 0,
    "invoiceTotalDeferred": 0,
    "invoiceCurrencyTotalDeferred": 0,
    "invoiceCompany": 1
  }
]

CSV_request:

This call will return the same data as above but as a simple downloaded CSV file

If "modelstructure=view", and a view number also specified, the CSV will contain the columns associated with the view - rather than a standard model

http://<SERVER>/csvapi/invoices.csv?user=user&password=user&version=4&company=1&client=1/F001&modelstructure=view&view=-1903