Matthew
Matthew4w ago

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:
@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.
Jump to solution
7 Replies
Gaurav Chadha
Gaurav Chadha4w ago
@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.
Matthew
Matthew4w ago
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
Matthew
Matthew4w ago
@Gaurav Chadha
No description
Gaurav Chadha
Gaurav Chadha4w ago
use a loop and iterate over the array of object then pass the item form the loop to the node's object.
Matthew
Matthew4w ago
not sure how to do that
Gaurav Chadha
Gaurav Chadha4w ago
cc @Luis can you help share a basic workflow remix for this?
Solution
Luis
Luis4w ago
@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.