Automatically Mapping JSON Keys to Columns in Clay
Hello! Is there a built-in way for Clay to automatically detect a text field containing JSON and allow me to quickly select which JSON keys to use for creating individual columns, similar to the parent/child column workflow? Hereâs the context:
I have an HTTP API enrichment that returns a text field in JSON format.
Currently, I manually use formulas (like JSON.parse) to extract each key/value pair.
Iâd like Clay to recognize the JSON structure and let me easily map JSON keys (for example, âcompany_nameâ, âall_products_reviewedâ, âproduct_descriptionâ, etc.) to their own columns.
Any guidance or recommended configuration for this would be greatly appreciated! Thank you!