Clay Icon

Troubleshooting JSON Parsing Issues in Enrichment Process

·
·

Hey there. I’m having an issue running an enrichment that parses a response into structured JSON. This is something that I’ve done successfully in the past, but it looks like the interface has changed a bit and maybe I’m not inputting my prompt correctly. Would you mind taking a look? Column in question is the right-most column (Prospect JSON parse) https://app.clay.com/workspaces/221295/workbooks/wb_iuzYdtruEpNQ/tables/t_r6NA9qKtSx9U/views/gv_tXSVjSgRfzpe

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To run an enrichment with structured JSON inputs:1. Go to "Add Enrichment" and select "HTTP API". 2. When formatting your JSON, ensure: • All text keys and values are enclosed in double quotes • Keys are properly separated by commas • No extra commas at the end of objects • Proper syntax is maintained throughoutFor example, use this format::LBKS{LBKS"name":: "John","age": 30}When using dynamic column values, make sure to enclose them in quotation marks. If you need to combine plain text with dynamic column data, create a Formula column first and then include that column (with quotes) in your body.If you encounter formatting issues, you can use a JSON validator like JSONLint to check your syntax. Sources: Find AI, Improved People Search, JSON Inputs, Weighted Round Robin, New Integrations, and more! FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment? HTTP API with JWT Authentication - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.