Hello All, I am trying to get a list of column values from my table via a API call. For testing purposes the table contains two columns. Column A=Company and Column B=Status. Column A contains a list of all companies and column B represents whether the company is Active or Deactivated. Using the action name โFindโ and omitting the Selector property, I get back all data for both columns, but when I try to use a selector (based on examples in the documentation) I get 500 internal server errors or depending on which expression I use I may get a success but no data is returned. To start Iโm just using the most basic example of:
{
"Action": "Find",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Selector": "Filter(Company, true)",
"Timezone": "Pacific Standard Time",
"UserSettings": {
"Option 1": "value1",
"Option 2": "value2"
}
},
"Rows": [
]
}
200 OK success, but no data is returned. Iโve tried multiple expressions using the Selector property, but none seem to work.
To add to this, my end goal is to get a list of all companies (column A) that have a status of deactivated (column B)
Any assistance on this would be greatly appreciated!
User | Count |
---|---|
19 | |
9 | |
8 | |
6 | |
5 |