Updating your Lookup Table via API

Owned by Brooke Gravitt (Deactivated)
Last updated: Oct 05, 2020 by Kenesha Sexton
2 min read

Lookup Tables can be vital for your business logic and email decisions, but what if the value in your tables changes weekly, daily, or even hourly?! In version 1.0.29, SmartHandler now supports updating your Lookup Tables via API. 


This is only for advanced users. 


GET, Retrieve All:

baseURL + /rest/fh/controllers/lookupTables/

GET, Retrieve One:

baseURL + /rest/fh/controllers/lookupTables/{tableID}


PUT, Update One:

baseURL + /jira/rest/fh/controllers/lookupTables/{tableID}


For updating, you will need two headers.

Content-Type : application/json
Cookie : {JSESSIONID=....}


Your body will look like this.

{
  "id": 5,
  "nickName": "Table Test",
  "columns": [
    {
      "id": 23,
      "name": "Customer",
      "values": [
        {
          "id": 182,
          "value": "Dunder Mifflin Paper Company",
          "rowNumber": 1
        }
      ]
    },
    {
      "id": 24,
      "name": "Point of Contact",
      "values": [
        {
          "id": 184,
          "value": "Michael Scott",
          "rowNumber": 1
        }
      ]
    },
    {
      "id": 25,
      "name": "Account Number",
      "values": [
        {
          "id": 186,
          "value": "004-1234",
          "rowNumber": 1
        }
      ]
    },
    {
      "id": 26,
      "name": "Account Manager",
      "values": [
        {
          "id": 188,
          "value": "Shane",
          "rowNumber": 1
        }
      ]
    },
    {
      "id": 27,
      "name": "Enterprise Account",
      "values": [
        {
          "id": 190,
          "value": "Yes",
          "rowNumber": 1
        }
      ]
    }
  ],
  "order": 0,
  "__moduleId__": "lookupTable"
}