Knowledge: How to lookup HighQ SiteID, SheetID and LinkColumnID
Back
    Title*How to lookup HighQ SiteID, SheetID and LinkColumnID
    ManualAdministration
    Manual Level TwoIntegrations
    Manual Level ThreeHighQ
    Created24/03/2020
    Detail

    Below 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:

    1. Navigate to the Site in HighQ and in URL look for metaData.siteID=1234, in this case 1234 would be the SiteID.
    2. 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:
      1. Target : sites
      2. Node XPath : //site
      3. OAuth Type : HighQ
      4. Output : sitename
      5. Output : id (this is the SiteID)

    iSheetID

    There are two ways to find the iSheetID:

    1. Navigate to the iSheet and look for metaData.sheetId=123 in the URL, 123 is the iSheetID.
    2. 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:
      1. Target : isheets/admin?siteid= append SiteID as found above
      2. Node XPath : //isheet
      3. OAuth Type : HighQ
      4. Output : title
      5. Output : id (this is the iSheetID)

    ColumnID

    There are two ways to find the iSheetID:

    1. Navigate to the iSheet and sort the relevant column, look for sortColumnID=123 in the URL, 123 is the iSheetID.
    2. 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:
      1. Target : isheets/[!SheetID]/columns replace [!SheetID!] with the ID from iSheetID instructions above.
      2. Node XPath : //column
      3. OAuth Type : HighQ
      4. Output : title
      5. Output : columnID (this is the ColumnID)
    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    Back to Top
    View or hide all system messages