Exporting JSON data

Hey there @Josh-Lopez, thanks a lot for all of the help that you are providing in these forums. I was wondering if you had any thoughts on this, I have this data that is in the member’s JSON object based on the Favoriting that they are doing on my website. I want to export a list of all member’s favorite vendors. Here’s a screenshot of how the data goes in to the JSON object…

How do I get this data OUT of memberstack and somewhere else where I can sort through it all (perhaps Google Sheets via running some sort of script/webhook to retrieve the metadata through this code:

MemberStack.onReady.then(async function(member) {    var metadata = await member.getMetaData()    // do stuff with members data})

:thinking:

I have consulted the documentation here https://help.memberstack.com/en/articles/3850012-front-end-api and haven’t been able to figure it out, I’ve also explored a webhook app through Zapier which did not work.

Thanks again.
–Elliott

Hey Elliot :wave:

Great question! This would be done with our new API https://docs.memberstack.com/endpoints/members-1#get-member