Adding multiple Sitemaps from Search Console Data Connector
Issue: We have over 90 sitemaps on average in our Google Search Console account that we want to report on. These sitemaps are added & removed regularly in Search Console using Google's API. Ie. one week we may have 92 sitemaps and the following week we may have 97 sitemaps.
We want to aggregate the numbers from these sitemaps into a single card.
But...the Search Console data connector allows us to select only a single sitemap per data connector.
One approach that we thought of is to create a data connector for each sitemap and then join the data using a Magic ETL data flow. But, this is not manageable since we would have to manually create new data connectors and update a magic ETL data flow frequently to keep up with any new sitemaps that are added to our search console account.
Another approach would be to make a direct call to the Search Console API using an HTTP rest api call (which would give us all sitemaps in one response) in combination with a JSON data connector. I don't think this is possible because you need to authenticate with OAuth2.0 and I don't think you can do that through the JSON data connector.
Is there another solution?
What would be the best approach to solving our problem?
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive