Skip to main content
Best answer

Fire different URL based on values from Excel Spread sheet

  • September 24, 2020
  • 1 reply
  • 85 views

Hi there,

I have an Excel Spreadsheet and in one of the columns (OfferId) i have values that need to be included in a URl. The ‘OfferID’ values are different for every row in the sheet.

Example. Row 1 of column “OfferId” could be “mXdkekdZSEDDE” and Row 2 of column “OfferId” could be “TvgMoloLPAAW”

So when firing a URL i need the URL’s to be

http://base-api-url/offer/mXdkekdZSEDDE/payment

http://base-api-url/offer/TvgMoloLPAAW/payment

 

I am trying to use Webhooks to accomplish this. But i see no option or not sure how to achieve this dynamic URL build and firing. Can someone please let me know if this is possible and if so how?

Cheers

Raghu

Best answer by Troy Tessalone

The Webhook URL can be a combination of static and dynamic values.

Example: http://base-api-url/offer/[OFFERID]/payment

[OFFERID] would be dynamically piped thru from a previous step.

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

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • September 24, 2020

The Webhook URL can be a combination of static and dynamic values.

Example: http://base-api-url/offer/[OFFERID]/payment

[OFFERID] would be dynamically piped thru from a previous step.