Knowledge: How to lookup HighQ SiteID, SheetID and LinkColumnID
Back
Knowledge
Title*How to lookup HighQ SiteID, SheetID and LinkColumnID
ManualAdministration
Manual Level TwoIntegrations
Manual Level ThreeHighQ
Created24/03/2020
DetailBelow are details on how to lookup he various ID's required to configure a data action:
SiteID
There are two ways to find the SiteID:
- Navigate to the Site in HighQ and in URL look for metaData.siteID=1234, in this case 1234 would be the SiteID.
- Create a new HighQ lookup data room. then create a RESTOAuth Data Action with following settings and then use in a form data action button as usual:
- Target : sites
- Node XPath : //site
- OAuth Type : HighQ
- Output : sitename
- Output : id (this is the SiteID)
iSheetID
There are two ways to find the iSheetID:
- Navigate to the iSheet and look for metaData.sheetId=123 in the URL, 123 is the iSheetID.
- Create a new HighQ lookup data room. then create a RESTOAuth Data Action with following settings and then use in a form data action button as usual:
- Target : isheets/admin?siteid= append SiteID as found above
- Node XPath : //isheet
- OAuth Type : HighQ
- Output : title
- Output : id (this is the iSheetID)
ColumnID
There are two ways to find the iSheetID:
- Navigate to the iSheet and sort the relevant column, look for sortColumnID=123 in the URL, 123 is the iSheetID.
- Create a new HighQ lookup data room. then create a RESTOAuth Data Action with following settings and then use in a form data action button as usual:
- Target : isheets/[!SheetID]/columns replace [!SheetID!] with the ID from iSheetID instructions above.
- Node XPath : //column
- OAuth Type : HighQ
- Output : title
- Output : columnID (this is the ColumnID)
Additional Manual Locations