API > Reading Records from a Table

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)

2 1 130
1 REPLY 1

Any assistance on this would be greatly appreciated!

Top Labels in this Space