iSheets API version 2 - iSheet module - API - iSheet item - get - single record
OVERVIEW
This method is used to get a list of iSheet items.
GET
For iSheet item ID: /api/3/isheet/{isheetid}/items/{itemid}
For external ID : /api/3/isheet/{isheetid}/items/byexternalid/{byexternalid}
Parameter Name | Parameter Value | Description |
---|---|---|
isheetid |
number |
The ID of the iSheet |
itemid |
number |
The ID of the iSheet item |
externalid |
String |
External ID which is assigned to a specific iSheet item for example EX102 |
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.
Andrew Quinn Thanks a ton Andrew that worked after I adjusted the permissions on folders as well. Not sure how I missed that. You are the best.
- Get File Info
- API Version >= 10
- emailmetadata query param = true
e.g. https://collaborate.highq.com/sitepoint/api/10/files/99999?statusinfo=false&emailmetadata=true
And example response:
{
"name": "",
"id": 99999,
"folderID": "8888",
"siteid": 7777,
"status": "",
"versionid": 1,
"versionnote": "",
"createddate": "21 Apr 2023 13:30",
"modifieddate": "21 Apr 2023 13:30",
"type": "eml",
"size": 11095,
"icon": "https://collaborate.highq.com/sitepoint/images/fileicon/large_eml.svg",
"commentscount": 0,
"likescount": 0,
"tags": {
"tag": null
},
"location": "Example Site > Email Received",
"createdby": {
"firstname": "Andrew",
"lastname": "Quinn",
"email": "example@acme.com.au",
"userid": 999
},
"modifiedby": {
"firstname": "Andrew",
"lastname": "Quinn",
"email": "example@acme.com.au",
"userid": 999
},
"permission": {
"view": 1,
"edit": 1,
"delete": 1,
"disableSave": 0
},
"contentstatus": 1,
"redactionstatus": false,
"emailmetadata": {
"from": "someone@acme.com.au",
"to": "example@acme.com.au",
"cc": null,
"sent": "21 Apr 2023 12:04",
"received": "21 Apr 2023 12:05"
}
}
Hope this helps,
Andrew
Is there a way to get the metadata from the files module? I want to grab to: field metadata from a file metadata isheet and while a view has the option to add meatadat to the view the view will not show the metadata and I cannot figure out a way to get it from the api in any way including using the file api.
I can download the file but I would rather grab this with the api for obvious performance reasons.
Has anyone else run into this? Any help would be appreciated.
Paul Ryan Sorry Paul, in tidying up the documentation in relation to your attachment queries, I came across this. I'm sure you've figured it out by now, but your assertion is correct (for the benefit of anybody who may be reading this many years later!)
Hi DOes anyone know if you can set the external id to be a specific column in the UI? Can it only be set through the api?
Urvi Parekh.. If you are sure that you have complete access of that iSheet. Then let me assign this case to iSheet technical team for more analysis.
Yogesh R Patel we need to trace this case by our side.. could you please check this case which is mentioned by Urvi. If possible then please raise a jira ticket.
CC: Amaresh Pandey
Urvi Parekh.. Status code 403 Means.. Validation failed/ Forbidden .. Could you check from your side that you have complete access of that particular isheet which you are passing in query param.
Vijay Vora ... I am getting a 403 error on that link you have suggested ,and until the bug has been fixed, is there an alternative way?
Urvi Parekh.. We have one API where you can get all isheet items and each item object contains item id attribute in 'item' Tag.
CC : Lisa Thompson | Imran Aziz
Vijay Vora / Lisa Thompson Hi, do you know where I can find the itemid? Thanks
Comments
11 Comments