DQL Check if a column exists

[y_buccellato]

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?

[MaciejNeumann]

Hello @y_buccellato,

Could you check if the "exists" function:
General functions - exists 
And "if" conditional function:

Conditional functions - if 

Can help you solve your use case?