Hello :-) New here can i get help with this? message:"invalid input syntax for type integer: "{"2"}""

Queries and Resources
1

I have this query
SELECT State FROM service_map WHERE id = {{Get_customer_data_from_url.data.State}}
State its a number i want to get the name of the state from another table running the query i get
message:"invalid input syntax for type integer: "{"2"}""

2

Hi @SEO_SEO, welcome to the community :wave:

Your input there id = {{Get_customer_data_from_url.data.State}} evaluates to id = {"2"}".
Have you checked your left-side panel to see what's the data structure for Get_customer_data_from_url?
You only want to pass exactly 2 in there or just number (no quotes or curly brackets included).

3

It makes it a bit difficult without know the data structure of {{Get_customer_data_from_url.data.State}} , can you share that?

Have you tried:

SELECT State FROM service_map WHERE id = {{ parseInt(Get_customer_data_from_url.data.State) }}