Using data from database for API call

I have an OpenAi api call thats works great. I have it setup with dynamic input that I assign in workflow.
My API call in workflow:

I would like to use data from the database to fill in to those dynamic inputs.

I can not figure out how to use “do a search for” where I point to AI_Prompt and retrieving the value for the field “model” in the data set with the name “prompt_name” = “GenerateEmailTask_DU2M3”

I can get so far as this:

Data fields:

Application data:

I hope I can get some help.
Thanks in advance.

remove double quotes in your search. You don’t need it

Thank you. I have spent to much time on that. :sweat_smile:

1 Like