We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to authenticate and use REST APIs from Excel VBA Macro?

Received Response
12
Views
1
Comments
edited Nov 25, 2019 5:17PM in Content Management 1 comment

Summary

Trying to use Excel VBA to authenticate and get documents using REST APIs

Content

Hi All,

I host some XLS files in my OCE and my business requirement is to access these ones from Excel VBA Macro (Excel document requires some data stored in XLS files).

I am trying to authenticate based on the link below:

https://docs.oracle.com/en/cloud/paas/content-cloud/developer/try-apis-using-oauth.html

but it is not so clear for me to build this solution using VBA.

Previously, I hosted the files on Beehive and just using these key line codes:

accessFile = "https://stbeehive.oracle.com/content/dav/st/{Workspace_name}/Documents/Others/****.xls&quot

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!