Clay Icon

Hey team, can I update a row using an api?

·
·

Hey team, can I update a row using an api?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can update a row using our API. We offer an "Update Row with Snowflake" action that enables you to update rows in Snowflake databases through our platform. This action utilizes Snowflake's UPDATE statement to modify existing records based on specified query conditions. It's available as part of our Enterprise plan and is classified as a native action. If you need help with JSON formatting or encounter any API-related issues, please share the JSON in the chat for further troubleshooting.

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    Can I do this without snowflake

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can update a row using our API without Snowflake. We offer an HTTP API integration that allows you to interact with your data directly. To use this, you'll need to set up an HTTP API request with the appropriate endpoint and parameters. The request should use a Content-Type of application/json. If you encounter any JSON-related issues while setting this up, please share the JSON in the chat so we can help troubleshoot further.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, You can add new values to a row using the API, but you can’t update an existing row directly. That functionality isn’t available yet. Let me know if you have more questions

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    gotcha ok, would love that in the future.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Got it - that makes sense. Curious, what were you trying to achieve here? I would like to add this with your feedback to our team so they can understand better your need! :)

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    want to trigger a workflow in n8n and then have it parse the data back into the same row

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Got it — and just curious, what does the workflow do exactly? The more details you can share, the better we can push this to the product team to support it properly.