Handling Database C...
 
Notifications
Clear all

[Solved] Handling Database Column Names that Contain Spaces  

   RSS

0

We have a customer MSSQL database that we need to query and the column names in the tables contain spaces. In ClearProcess, how do I query such a column without getting an invalid JSON error? 

1 Answer
1

Figured it out. In the pre-processing rules, you need to put square brackets around the column name:

{
  "table": "LabelsForClear",
  "where": [
    {"column": "[Valid From]", "operator": "=", "value": "2020-08-04T00:00:00"}
  ]
}

Share: