How I Automated Pulling 200+ Transaction Details in 5 Minutes

My colleague from the support team reached out to me asking me to pull the transaction details of 200+ transactions in a single go. He had the order ID. I thought about it. There are multiple ways to get the data. I could create a ticket for the tech team to generate a report based on the order IDs, which would take time. Or I could search one by one in the dashboard, which is again time-consuming.

Then I thought—Is there an API where I can input the order ID and get the transaction details? I found it! It’s called List All Charges API. I tried querying one order ID, and I got the data.

Next, I thought about how I could perform the API operation in bulk. I could use Postman automation, but that would take time to write the scripts. Then another idea struck me—why not try Pabbly Connect, an automation tool?

I asked my colleague to put the data in a Google Sheet, adding extra columns for the required details like amount, date, payment method, etc. Then, I opened Pabbly Connect, created a workflow connecting Google Sheets and the List All Charges API, and mapped the required fields from the API response.

I started the operation for 200+ records and got all the data in less than 5 minutes. Job done!

These are the small ideas we can apply in our workplace or daily computing—fun to learn, try, and save time & effort. Smart work will save your life!