Matthew - Hey i have a large json data set comi...
Hey i have a large json data set coming in from an API. I want to parse that data then add it to my supabase table how do i do that
Solution:Jump to solution
@Matthew, Sharing a workflow here that can guide you how to achieve what you're trying to do. Notice in the object input how you can access the specific fields you want to insert in your supabase row. https://buildship.app/remix/6582d840-ddac-479e-a646-45111f1d96d7
BuildShip - Visual backend workflow builder
Visually build workflows and powerful backend logic for your apps. Powered by AI, connect to anything with or without code.
7 Replies
@Matthew, you can simply pass the json in the object field of the Create Row Supabase node, you cna refer to this documentation - https://docs.buildship.com/tutorials/supabase-crud#creating-data
Integrate Supabase DB with BuildShip – BuildShip
A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.
Ive tried that but it puts the json im getting from the api request in one row, rather than create muliple rows based off the array of objects
@Gaurav Chadha
use a loop and iterate over the array of object then pass the item form the loop to the node's object.
not sure how to do that
cc @Luis can you help share a basic workflow remix for this?
Solution
@Matthew, Sharing a workflow here that can guide you how to achieve what you're trying to do. Notice in the object input how you can access the specific fields you want to insert in your supabase row. https://buildship.app/remix/6582d840-ddac-479e-a646-45111f1d96d7
BuildShip - Visual backend workflow builder
Visually build workflows and powerful backend logic for your apps. Powered by AI, connect to anything with or without code.