Combine API data with Database data

EDIT: After some help from @sid I now have a much better solution than I originally had so I’ve deleted the original post to avoid confusion. The substantially better way to do this is…

image1557×1730 206 KB

A few notes…

1. Create your API action with a static URL first to get the schema then create the dynamic_url and change the URL in your API action to use that.
2. Make sure to have Output ticked in the repeat action, and the values you want to output.
3. For any fields you want to use from the API output them in the repeat action
4. Make sure to use a Database Single Query to get your database info.

Hope that helps. Thanks to @mebeingken and @sid for their help!