bearer token (1 Viewer)

[irade92]

Hi

How do I send a POST Request with Bearer Token Authorization Header? .​

 

[conception_native_0123]

what library are you talking about using? you are referring to authentication protocol 2.0 but there are a million ways to do this with a few different libraries I believe. the first thing that comes to mind is this:

Referencing MSXML within VBA Projects

docs.microsoft.com

 

[theDBguy]

Have you checked the documentation from the provider, if they have any?

 

[irade92]

Hi

How do I send a POST Request with Bearer Token Authorization Header? .​

I am retrieving a Json token with API method and then as a header I put it as a bearer token using POST to get some XML file
for example...
mToken= "ksgfkasgklgkglfpjgRPOAGIOopeijiofjagfm"

req.Open "POST", "https://grmmapi.st/api/Prescription/AllPrescriptions?insuredPersonId=" & Me.mEZBO_ERECEPT, False
req.getResponseHeader "Authorization", "Bearer " & mToken
req.send


is this formulation ok?

 

[conception_native_0123]

it seems to be, based on others that were doing the same thing but with a different method:

How do I authenticate using MSXML2.XMLHTTP and VBA?

I need to authenticate on the endpoint https://graph.microsoft.com/v1.0/me/drive/root/children using MSXML2.XMLHTTP and VBA. I have the access token already but I am struggling to find out the str...

stackoverflow.com

Using VBA to get data from API with bearer token to Excel

So far I have been using Postman to GET data with our bearer token. I need to get this data into Excel. So far what we've done is download the .json using postman, convert the .json to .xml and ope...

stackoverflow.com

I've never seen people do this with POST before, but the difference between POST and GET methods is intake length only, if I remember right. still not understanding what your question is about though, sorry. =(

 

[ByteMyzer]

I am retrieving a Json token with API method and then as a header I put it as a bearer token using POST to get some XML file
for example...
mToken= "ksgfkasgklgkglfpjgRPOAGIOopeijiofjagfm"

req.Open "POST", "https://grmmapi.st/api/Prescription/AllPrescriptions?insuredPersonId=" & Me.mEZBO_ERECEPT, False
req.getResponseHeader "Authorization", "Bearer " & mToken
req.send


is this formulation ok?

You will need to change:

req.getResponseHeader "Authorization", "Bearer " & mToken

...to:

req.SetRequestHeader "Authorization", "Bearer " & mToken

 

[irade92]

You will need to change:

req.getResponseHeader "Authorization", "Bearer " & mToken

...to:

req.SetRequestHeader "Authorization", "Bearer " & mToken

thanks a lot