Append select data

Summary:

Hi

I am getting AP line data from SQL Query1 and based on condition need to merge SQL Query2 AP line data into SQL query 1 .

Then need to Send AP line data to AP invoice rest API.

Attached sample Query1 response.

How we can do in OIC?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):