Hi all!
I've integrated API's of a payment service provider and I've setup a webhook url with them to receive status updates of the payment transaction I make. Now what I've observed is when I make an API call to create a new payment it goes through successfully and I get a webhook event on the configured url as expected, I can see in the request history that I get all the data which I am expecting from provider including the correlation id (clientPaymentRef - see this in the attached image) which I require to query my database table against for updating the status of the record.
I've added a "Query all records" function to check the existence of the record and it is returning me a null value. If I use copy the payload from the request history and then Run & Debug the API it successfully queries the table with the record and handles the webhook event successfully.
I tried trimming the correlation id with the hope that it might work but no luck there too.
Also I tried sending the correlation id which I got from the payload (Get all raw input) in the API response and to my surprise I can very well see it in the response.
Here is the request payload which I get as a webhook event from the provider
And here is the output from the API
Has anyone faced a similar issue or have a resolution to this? I've been stuck with this issue for almost a week now, any help/suggestion would be appreciated. Thanks!