peskywinnets
Registered User.
- Local time
- Today, 12:33
- Joined
- Feb 4, 2014
- Messages
- 576
Really struggling here wrt constructing the initial API call (for Shopify) ...there's not a lot of related info via a google search.
Has anyone got any code to get me off the ground?
All I seek is the most basic of code to construct a proper formatted get request using Shopify API key (username) & secret key (password)
here's the URL that works... (this is just a test site that will be deleted in a week or so, so I'm not worried about sharing the keys)
(in other words if you copy that URL into a browser you don't get an error)
I'm clearly missing the point re how to reconstruct the above in VBA, here's what I've done (which is wrong)....
Any top tips?
Has anyone got any code to get me off the ground?
All I seek is the most basic of code to construct a proper formatted get request using Shopify API key (username) & secret key (password)
here's the URL that works... (this is just a test site that will be deleted in a week or so, so I'm not worried about sharing the keys)
(in other words if you copy that URL into a browser you don't get an error)
I'm clearly missing the point re how to reconstruct the above in VBA, here's what I've done (which is wrong)....
Code:
Public Function Shopify()
strLogin = "https://pht-store.myshopify.com/admin/api/2021-01/orders.json/authenticateUser?login=d6615cf12fa04c957a470c5d18d50a52&apiKey=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"
Set XMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0")
XMLHTTP.Open "GET", strLogin
XMLHTTP.setRequestHeader "Content-Type", "text/xml"
XMLHTTP.send
strReturn = XMLHTTP.responseText
Debug.Print strReturn
Any top tips?
Last edited: