cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL Check if a column exists

Hello,

I'd like to execute a DQL that check for a field "custom_headers" if it exists.

 

If it exists I'd like to perform a subsequent set of operation like the following:

| expand custom_headers
| filter matchesPhrase(custom_headers, "\"name\":\"SalesOrderId\",\"value\"")
| parse custom_headers, "JSON:SalesOrderId"
| fieldsAdd SalesOrderId[value]
| fieldsRemove custom_headers, SalesOrderId

If it doesn't exist the query can finish without executing those set of instruction.


Is that possible in DQL?

0 REPLIES 0

Featured Posts