Handling Database C...
Clear all

[Solved] Handling Database Column Names that Contain Spaces  



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

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"}


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