SharePoint REST Connector

PetteysJ
Member
in Connectors
Hoping someone has run into this when connecting an Excel sheet from a SharePoint.
My header row (row 10 as it happens) has a blank in cell A of that row. Instead of pulling it in as Column_1 as I would expect, it removes that cell and shifts all other headers over. Not only do the headers end up shifted, but it fails to pull the last column of the sheet I need.
Is there a way around this?
Tagged:
0
Answers
-
If you are able to edit the Excel document and put some dummy data in that cell, that seems like the easiest solution.
Another option would be to start at an earlier row and then filter out the header rows in the ETL by looking for certain information and then create your own column names with the select columns tile in the ETL.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 802 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive