List API Call Limit

[Shlomi Dvir]

The List API has a limit of retrieving only 100 records per API Call. If I have more than 100 records in Sage Intacct, how can I retrieve all the records with one API Call.  What is the procedure?

[Sterio, Louis]

I believe you will need to use the query service for this:

https://developer.sage.com/intacct/docs/openapi/common/core-query/tag/Query/

 

[Shlomi Dvir]

When I tried to use the query service, I am Getting an invalidRequest

invalidRequest.

[Preston, Charlie]

Looks like the object needs to be the complete path company-config/department and the comma on line 11 isn't needed.

This works for me:

{

  "object": "company-config/department",

  "fields": [

    "id",

    "name",

    "status",

    "href"

  ],

  "filters": [

    {

      "$eq": {

        "status": "active"

      }

    }

  ],

  "orderBy": [

    {

      "id": "asc"

    }

  ]

}

[Preston, Charlie]

Also looks like you need to set the "size" parameter to the page size you want and the "start" parameter to the starting position so you can page through the results.

{
  "object": "company-config/department",
  "fields": [
    "id",
    "name",
    "status",
    "href"
  ],
  "filters": [
    {
      "$eq": {
        "status": "active"
      }
    }
  ],
  "orderBy": [
    {
      "id": "asc"
    }
  ],
  "start" : 1,
  "size" : 1000
}

The response gives you the total number of records, starting position and next position so you can make a subsequent call to retrieve the next page.

  "ia::meta": {
    "totalCount": 7,
    "start": 1,
    "pageSize": 1000,
    "next": null,
    "previous": null
  }