Join a database table with API data

[mebeingken]

Okay, this works for me.

Try ticking the output box for the Set Value action within the repeat. If I remove the output, then I receive the same error.

[Heather_Mann]

AHA!!! That worked to get the final_list.

However I’m still getting No Results when I run the query.

[mebeingken]

I have mine setup to use column type Numbers…maybe your tripbit_id is a string field? If so, then remove the toNumber() in the Set Value idvalue.

[Heather_Mann]

No - it’s an INT field. I tried removing that anyway and it’s still No Results.

[mebeingken]

@Heather_Mann

However I’m still getting No Results when I run the query.

Just to be clear...you mean when you hit the play button within the query, correct? If so, then that will be using the test value, which you show as empty.

Running the file, is the only way to see the expression in use.

[Heather_Mann]

Well, duh! Of course.

It’s working perfectly now. Thank you so much for your help. I really appreciate it!

[mgaussie]

@mebeingken

You have to pass parameters into your custom sql query – you can’t use the dmx {{}} type of syntax directly in your query.

Hey mebeingken, do you know if it's possible to pass parameters to the query to be used for inserting dynamic values?

E.g. I'm using an INSERT custom query, and I have some JSON i'm including directly in the query (this inputs correctly with static data) - I'd like to replace some of the values in the static JSON with dynamic data using :P1 + a dynamic expression. Do you know if this is possible?

[Teodor]

That’s already possible using the Server Connect Array List component:

Working with Server Connect Array Lists

Intro The Server Connect Array List component allows you create and manipulate Array Lists easily with Server Connect actions. You can add items to an array, join multiple sources, remove and set arbitrary items, keep simple or complex objects or collections in an Array List. It’s also easy to use it as a string builder, when you need multi lines strings. Basics In order to be able to add items to an array you first need to define the array. The Array List actions are located in the Data Man…