Skip to main content
Solved

How do we get Company by GSID using the API

  • 8 June 2024
  • 1 reply
  • 24 views

I have a company GSID from another API call.

Now I want to fetch company information using that GSID

I tried using this documentation - https://support.gainsight.com/gainsight_nxt/API_and_Developer_Docs/Company_and_Relationship_API/Company_API_Documentation#Read_API

 

The POST body that I am using is below

{
  "select": "
    "gsid",
    "Name",
    "Industry",
    "Stage",
    "Users"
  ],
  "where": {
    "conditions" :  
      {
        "name": "gsid",
        "alias": "A",
        "value" : "<GSID VALUE HERE>",
        "operator": "EQ"
      }
    ],
    "expression": "A"
  },
  "limit": 100,
  "offset": 0
}

I keep getting a HTTP 500
 

{
    "result": false,
    "errorCode": "GSOBJ_1017",
    "errorDesc": "Server Error Occurred, Please contact support",
    "localizedErrorDesc": null,
    "requestId": "132e0b79-1064-4b74-8ea0-0ceb0e728dda",
    "data": null,
    "message": "Internal Server Error Occurred. Please contact support team.",
    "localizedMessage": null
}

 

Also, where can I find documentation for the query language used in the documentation

1 reply

M

Figured it out, the “value” expects an array. It would be nice to have some documentation of the query language.

 

This worked!

{
  "select": [
    "gsid",
    "Name",
    "Industry",
    "Stage",
    "Users"
  ],
  "where": {
    "conditions" : [
      {
        "name": "gsid",
        "alias": "A",
        "value" : ["<GSID VALUE HERE>"],
        "operator": "IN"
      }
    ],
    "expression": "A"
  },
  "limit": 100,
  "offset": 0
}

 

Reply


Terms & ConditionsCookie settings