Question

Webhook not pulling through transaction data

  • 22 November 2021
  • 1 reply
  • 7 views

Having trouble with data being pulled through a webhook from a website that requires a login to get transaction data through an affiliate company merchant using Post Affiliate Pro. 

 

https://support.qualityunit.com/873987-Available-tracking-parameters

https://support.qualityunit.com/573712-Affiliate-Sale-Tracking-Codes

 

API for the transaction as an affiliate is not possible they say so we setup a webhook to pull a few items you can see with the following 2 links for webhooks into a google sheet. 

 

https://hooks.zapier.com/hooks/catch/XXXXXXXX/XXXXXXX/

 

https://hooks.zapier.com/hooks/catch/XXXXXXXX/XXXXXXX/?clientname={$saledata1}&clientemail={$saledata2}&clientphone={$saledata3}&totalcost={$totalcost|currency}&totalcommission={$commission|currency}&productpurchased={$saledata4}

 

 

id

43

row

43

COL$A

{$saledata1}

COL$B

COL$C

{$saledata2}

COL$D

{$saledata3}

COL$E

{$totalcost|currency}

COL$F

{$commission|currency}

COL$G

{$saledata4}

 

that is what comes through without actually bring the transaction line item - it just dumps those bracketed text
 

This post has been edited by a moderator to remove sensitive information. Please remember to remove any personally identifiable information prior to posting as this is a public forum. 

 


1 reply

Userlevel 7
Badge +9

Hi @Faster Way with Nicki. Welcome to the Community! :)

The text in the curly brackets isn’t how I’d expect a selected field to appear. Did you manually type in those values ({$saledata4} etc) into the fields on the Google Sheets step? Or did you select them from the Webhook step

If you could send over screenshots showing how you’ve set up the Webhooks by Zapier and Google Sheets steps (with any personally identifiable information obscured) that will help us to get a better idea of why those values aren’t being sent over to Google Sheets as expected. Looking forward to hearing from you! 

Reply