iSheets API version 2 - iSheet module - API - iSheet item - get - all items
OVERVIEW
This method is used to get a list of iSheet items.
GET /api/3/isheet/{isheetid}/items?sheetviewid={sheetviewid}&sortcolumnid={sortcolumnid}&sortorder={sortorder}&limit={limit}&offset={offset}
Parameter Name | Parameter Value | Description |
---|---|---|
isheetid | number | The ID of the isheet |
sheetviewid | number | Optional. Default view will be returned |
sortcolumnid | number | Optional. First column sorting will be applied |
sortorder | number | Optional. Default value : 0 |
limit | number | Optional. Default value : 100 |
offset | number | Optional. Default value : 0 |
Response Body
a iSheet item - common object - get
Note : As seen in the UI, the response will be shown with iSheet views in the correct sequences.
Peter Naylor I'm not sure - Natasha Miller-Santos do you know? Maybe we need to check with the engineering team.
Is it possible to get all the data from an iSheet regardless of column condition logic? Our clients need some columns and fields hidden from them, but we need to still be able to read the full dataset via the API.
Hi Kieran Widdowson - please can you raise a support ticket to have this investigated further? I am not able to check this for you unfortunately.
CC: Hamza Khan
Hi Lisa Thompson, I am querying the iSheets endpoint for the first time and getting a 403 Access Denied error - has our instance been upgraded? Other endpoints seem to be working fine
Hi Urvi Parekh - I'm sorry about this, we checked and unfortunately you will be upgraded this coming Saturday 4th August. Saturdays are one of the scheduled times that our clients are upgraded and only a set amount of upgrades can happen in the time frame and any that cant be fitted in are scheduled in for the following weekend. I'm sorry for the inconvenience this may cause.
I'm getting a 403 Invalid ItemId all of a sudden. Did anything change on this endpoint?
Imran Aziz I greatly appreciate the update.
Jeremy Gossett please note that we have upgraded the Sandbox instance https://integrationbeta.highq.com to 4.3.1 release so JSON related issues should be sorted now. Thanks
Jeremy Gossett 4.3 is still not released and the first release of 4.3 will have this fix. We will deploy this fix to integrationbeta instance in a week or so.
Imran Aziz Is there a release schedule anywhere on the site, or could you let me know when this might be released? I'm currently working on a project that requires this feature and I would like to know if I need to write an adapter for now or wait.
Jeremy Gossett the technical team has confirmed this to be a bug and are now resolving this issue. We will release the bug fix in the next point release.
Imran Aziz I have tried through postman, similar to the example in the video, and it seems as though I am still getting a response in xml, or some type of html format. I have set accept as my header with the application.
Lisa Thompson yes we support both XML and JSON response, please set "accept" header as "application/JSON" and the API will return the response in JSON format.
Imran Aziz - Do you know when the response can be with json please? Thank you.
Absolutely no problem Dan Hey, I am working on this right now and I will let you know when I get somewhere =).
Thanks Jeremy Gossett
I have been told the request is only xml but, the response can be json. I have not confirmed this yet.
Is the response available in JSON for "get all isheet items"?
Comments
20 Comments