How to insert variable value in SQL

  • 12 January 2023
  • 2 replies
  • 188 views

Badge

I have a use case where I want to dynamically change the SQL query in the Postgres integration with Zapier. In short, is there a way for Zapier to insert a value form a cell in a good sheet into a part of the SQL query? 


As an example: I want to look up data for a customer based on the customer name that is in the cell or if its added as a row in a sheet. The SQL query should change the value of the customer name so it can extract the correct data. 

Is this possible? 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Badge

@christina.d does this also need to be moved into the webhooks and code section as it is more technical? 

Badge

@christina.d Is there anyone on the team who may be able to provide guidance?