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.
| Warning |
|---|
This is only for advanced users. |
GET, Retrieve All:
| Code Block |
|---|
baseURL + /rest/fh/controllers/lookupTables/ |
GET, Retrieve One:
| Code Block |
|---|
baseURL + /rest/fh/controllers/lookupTables/{tableID} |
...
| Code Block |
|---|
baseURL + /jira/rest/fh/controllers/lookupTables/{tableID} |
For updating, you will need two headers.
| Code Block |
|---|
Content-Type : application/json
Cookie : {JSESSIONID=....} |
...
| Code Block |
|---|
{
"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"
} |
| Info |
| This is only for advanced users. |
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...