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.
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.
Fetched a list of customers recorded by ReviewAccelerationFX and ordered the results in a spreadsheet.
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)