Best answer

Fire different URL based on values from Excel Spread sheet

  • 24 September 2020
  • 1 reply
  • 74 views

Userlevel 1

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

icon

Best answer by Troy Tessalone 24 September 2020, 08:24

View original

1 reply

Userlevel 7
Badge +14

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.

Reply