Mapping Excel Online Import
I am trying to create an integration connecting a report from Quickbook to Excel Online. I have all connections online and I can't figure out how to map to Excel Online. I tried Mapper both 1.0 and 2.0 in import but there is no drop down option to in the destination field. I am not sure if it has to do with how I configure in the import or something with Mapping.
0
Comments
Hi Thao Dinh,
If you're looking to update the cell values in an excel sheet, you can use the "Update Range" endpoint. https://learn.microsoft.com/en-us/graph/api/range-update?view=graph-rest-1.0&tabs=http
There is an important note about this, which is the limit of 20,000 cell values per call. So if your sheet has 20 columns, you can only post 1,000 lines per call. For such a use case, you'll want the "address" values of your URI to be dynamic. Here's some documentation about this cell limit: https://learn.microsoft.com/en-us/answers/questions/1303802/graph-api-fails-to-update-range-in-excel
For the call from integrator.io, you might want to use the HTTP view of the import screen. See example below:
I've introduced a template in the marketplace for working with Excel Online:
Please sign in to leave a comment.