Using data from database for API call

thomas.n.3000 · 2025-04-01T15:29:20.642Z

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:

image521×473 21.5 KB

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:

image507×506 16.8 KB

Data fields:

image514×773 24.7 KB

Application data:

image931×575 22 KB

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

Jici · 2025-04-01T15:36:12.165Z

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

thomas.n.3000 · 2025-04-01T18:27:42.052Z

thomas.n.3000:

“GenerateEmailTask_DU2M3”

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