Hi, Is there a way to return a dynamic value from a database query that contains multiple columns? For example: Query Name: GetItem SELECT Item 1, Item 2, Item 3, Item 4, FROM Items WHERE ID LIKE ? 1 Then when I go to “Insert Dynamic Data” and make the API call from the database connector using…

Inserting multiple items into a dynamic value from a single database query

sharonherzog April 7, 2016, 8:10pm 2

Nevermind, I achieved what I was looking for using a repeating group with 1 column and 1 row. If there’s a better way to do this please let me know.

Thanks.

Topic		Replies	Views
Insert multiple dynamic rows into external DB APIs	4	666	May 24, 2022
How to make an API response that contains multiple items into single rows in the database Need help	2	662	June 20, 2016
Inserting multiple rows via SQL Connector Database	6	2463	July 23, 2020
Database stores data in one row instead of several Database	8	1563	April 22, 2021
Write dynamic data to SQL DB Plugins	8	2861	November 4, 2016