Is there a way to return a dynamic value from a database query that contains multiple columns?
Query Name: GetItem
Item 4, FROM
ID LIKE ? 1
Then when I go to “Insert Dynamic Data” and make the API call from the database connector using ‘GetItem’s Item 1 Item 2 Item 3 Item 4’
Right now I can only seem to enter the dynamic data “GetItem’s Item 1” for 1 item and then I have to make another query for the other 3 items.
Is there a way to do this so I can minimize the calls to the database (1 versus 4)?
Thanks for your help,