Microsoft 365 Excel Connector

Hey @gio can you help on this ?

Connected with the 365 Excel Connector, but facing an admin token issue, kindly check the below screenshot:

how to resolve this admin token issue ?

Thanks,
Shashi

Hi @gio ,

Any update on this ?

Thanks,
Shashi

hello @psp316r, apologies for the delay. it seems like there isn’t a token included in your request. just to confirm, have you taken a look at this Support Article: Microsoft 365 Excel Connector | Tulip Knowledge Base - Support for Building Operations Apps??

as you can see, you will need to get the Token and enter it in your Connection Details. could you add it and let us know if that works for you?? thanks!!

Hi @gio ,

Was Confused were to get the Token from, followed the same article shared by when started the task, any idea where to get the Token from ?

Thanks,
Shashi

hello @psp316r, this article from Microsoft has information on registering your App and getting an Authorization Token: Authentication and authorization basics for Microsoft Graph - Microsoft Graph | Microsoft Docs.

let us know if you have any questions while getting this token!!

Hi @gio ,

Can we connect any third party excel sheets except Microsoft Graph, is it possible in Tulip ?
Because For Microsoft Graph, need to access the Azure Active Directive Services, as of now there is no access.

Thanks,
Shashi

Hi @psp316r ,

Currently, Excel & other Microsoft services can be integrated via Microsoft Graph.
I would like to understand what is your use-case & what third party excel sheets are you referring to?

Thanks,
Sagar

Hi @Sagar and @gio

Use Case, Client should be able to store the data in the Excel sheet and also able to read the data from the excel sheet. Is this Possible ? do Tulip has an work around for this ?

will it be possible to read the data from excel sheet from local machine ?

Thanks,
Shashi

Hi @gio and @Sagar

Any update on this ?

Thanks,
Shashi.

hello @psp316r, there was a similar question to this in which it was recommended to use CData or Node-RED on an EdgeMC to access information stored on locally on a machine. this is the Topic: File Operations that includes more information.

would either of these solutions work for you??

Hey squad,

I wanted to share this video here for how to set up the connector from the library

2 Likes

Hi @gio ,

@freedman thanks for sharing this, Nod-Red will be the perfect work around for us as per the Client Problem Statement.

Thanks,
Shashi.