Hitting the MCFX API to get a list of all customers recorded by RAFX

Posted by: Ed Hungerford Date Posted: May 15, 2025
Back to Case Studies

Issue

CH Reed wanted to have a list of every customer picked up by RAFX that didn’t receive the survey email. The RevenueCloudFX backend allows us to export everyone who did receive it, but not anyone who didn’t.

Solution

The MCFX API does store the data we’re looking for. Using this Guru card and Postman, I was able to connect to the MCFX API and gather the data using this endpoint: https://api.webfx.com/mcfx/reviewboost/ratings?association=2067&$sort[rated_date]=-1&$limit=-1

I copied all of that down into a file and used a little JavaScript to turn it into a CSV. Then, I uploaded that to Google Sheets, filtered the data a bit, and sent it over to the client.

Achievement

Fetched a list of customers recorded by ReviewAccelerationFX and ordered the results in a spreadsheet.

Snippet/Screenshot/Link

var myJSONs = [ //YOUR DATA FROM THE API HERE
].map(function(customer){
return `${customer?.first_name};${customer?.last_name};${customer?.email};${customer.sent}`
}).join("\n")
console.log("First name;Last name;Email;Sent\n" + myJSONs)