Forum Academy Marketplace Showcase Pricing Features

How to make an API response that contains multiple items into single rows in the database

I have an API that returns multiple values for a field. For instance:

ID: {123,124,125,678…}

I want each value to be on its own row in my table.

Right now, it is putting the entire list on a single row.

How do I parse out the result to have each result be its own record in the table?

If it is an array (of name value pairs), then you can set that as the main list and pull them back.

But that looks more like a list of values. Do they now come back ok ? I know we had a problem last week.

This is a different call - in this case it is a list of values. If I get a list of values back, how do I store them in the database as multiple lines, instead of one column with multiple values?