iSheets API version 2 - iSheet module - API - iSheet item - get - single record

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.

Morgan Newman,

• 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

Vijay Vora....I do have complete access

 

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.

Please refer https://developerportal.thomsonreuters.com/isheets-api/documents/isheets-api-version-2---isheet-module---api---isheet-item---get---all-items

CC : Lisa Thompson | Imran Aziz

Vijay Vora / Lisa Thompson Hi, do you know where I can find the itemid? Thanks