al4629740
asked on
How do APIs work?
So I am trying to connect Office 365 and WebMerge together so that data can be extrapolated from Excel. How exactly does this whole API process work. Do both applications need to typically have an API id and secret or just one? What exactly is an API and how does it work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try it. I think you have to first register your app (web hook) https://docs.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/app-registration?view=odsp-graph-online then add your credentials https://docs.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/authentication?view=odsp-graph-online
ASKER
Ok, I will. At the end of the day, webmerge will be used for Excel online, but imagine everything mentioned still applies.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, I think we are looking at integromat also
ASKER
It looks like zapier is free with a Microsoft account. I'm guessing that might be a good way to go. So would I still need any of the client ID and secret in setting it up with zapier? It seems I would only need that if it was a direct connection.
When you set up the zap, it walks you through the process of connecting. If you are not logged in, you get the pop up to log in, then authorize. Otherwise, just authorize. In this case, you don't have to do anything else.
ASKER