Clay Icon

Exporting a Table via API: Seeking Solutions for Custom App Integration

·
·

Hi Clay S. quick question, is there any way we can export the whole table via the API ? I want to send it the whole table with data to my custom app. Any ideas how to do it ?

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Romeo, thanks for reaching out! Yes, you can push records from your table to a custom app using the HTTP API. Here are some resources to help you get started: -Quick video on how the HTTP API works: Watch here -Troubleshooting example for failed body parse issues: Watch here I’ve also made some adjustments to the JSON body you were pushing, and the column seems to be running now. Additionally, we’ve recently updated our HTTP API enrichment column to align with standard JSON structuring practices: - Numbers are unquoted to enable arithmetic operations. - Strings are quoted to preserve their exact format, including special characters or leading zeros. - Quotation marks help distinguish text data from numeric values for accurate parsing and interpretation. Here’s a video explaining these updates: Watch here. I hope this helps! Let me know if you have any other questions.

  • Avatar of Romeo M.
    Romeo M.
    ·
    ·

    Thanks I was thinking of this, was thinking of a batch method rather so i send all data. But this works also

  • Avatar of Romeo M.
    Romeo M.
    ·
    ·

    I was just thinking how to export for example multiple cells(without making new columns) that have their own Json structure, take full company enrichment, profile enrichment, tech stack, etc. Makes sense? But I suppose I will just have a huge JSON if i could eventually nest everything in one JSON. The use case is with Replit.

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Happy to help, let me know if you have any other questions as you set the HTTP API up here.

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    The HTTP API enrichment sends one call per row, using the data from that specific row. Rows are not aggregated, so Replit will receive an individual JSON object for each lead processed through the HTTP API.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Romeo M.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: