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? 

2 Answers
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"}
  ]
}

0

I am filled with pride when I think about what you have achieved in such a short period of time. While some people will devote their lives to achieving your level of success, this is just one step for you. Congratulations on this success. Can't wait to meet you upstairs!

treat-assignment-help | treatassignmenthelpuk

Share: