Question:
I am currently building a centralized data platform for a non-profit who has a website hosted by Wix. My end goal is to collect Wix data, marketing data, credit card charge data, and social media analytics data into one single location. I’ve already set up a connection to the Wix REST API and am programmatically accessing the relevant endpoints, like members, blog posts, etc. However, from what I can tell, the data contained in the generated Looker reports in the analytics tab of the website dashboard can only be manually downloaded. I know I can subscribe to a scheduled email to get these reports, but I’d like to ask if there is a different way to query this data?
What have you already tried:
Currently, I am subscribed to scheduled emails, which does provide an alternate point of entry to access the data. While this is usable, it is a bit cumbersome and convoluted.
Additional information:
I’m already connecting to the REST API from Airbyte, so if there is a solution compatible with Airbyte, that would be ideal.