Recent content by peskywinnets

Actually, I got lucky, within about 30 mins of trying different permutations, this code actually works... Public Sub Parcel2Go_GetAccessToken() Set XMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0") ClientID = "aaabbbcccdddeeeff" ' this isn't my real ClientID :-) ClientSecret = "xxyyxzz" '...

I've got several APIs working in access, but the headers & string formation is always a challenge ...every time I'm faced with a new one, same issues...and no examples for VBA,

Does anyone have the 'chops' to be able to arrange the following short snippet of code into VBA... POST /auth/connect/token HTTP/1.1 Host: sandbox.parcel2go.com User-Agent: insomnia/5.14.6 Content-Type: application/x-www-form-urlencoded Accept: */* grant_type=client_credentials...

I appreciate the input ...I may be mis-intpreting how to use what you've suggested - the error is thrown up in the json module itself (not in the function where my code is) ....& I don't want to deploy anything in the JSON module I'll google a bit more, because I find it difficult to believe...

I'm trying to parse using the popular VBA JSON parser, but because a key doesn't exist, my code breaks with a Run-Time error 13 Type Mismatch. Here's my line of code... EbayTaxType = json("lineItems")(1)("ebayCollectAndRemitTaxes")(1)("taxType") ...I've done a google search, but I'm going...

Because I'm out my depth! I've just found a post where someone seems to have made a successful Amazon API call using Version 4 signing (which is where I came unstruck)... https://stackoverflow.com/questions/75663343/create-a-signed-aws-api-request-to-a-lambda-function-url-from-excel-vba ...so...

At the foot of this page are some examples in various languages to do with the signing ... https://docs.aws.amazon.com/IAM/latest/UserGuide/create-signed-request.html

With their old MWS API (XML based, which is now going end of life) I managed to get the signing/encoding working (albeit, it took me a while as there is scant information for using VBA for making API calls), with this new SP-API (I think the SP stands for selling partner...its REST/JSON type)...

I have the same problem...I coded up my own VBA/Access based solution for the old MWS API, but the signing aspect is excessively complicated for the new SP-API (with little information on the web how to accomplish this in VBA)...so I'm facing being cut-off from retrieving Amazon data via API...

I've replicated the JSON structure with test data.... { "href":"https://api.ebay.com", "total":"30", "next":"https://api.ebay.com/next", "limit":"50", "offset":"0", "orders":{ "0":{"OrderID":"Order1"}, "1":{"OrderID":"Order2"}, "2":{"OrderID":"Order3"} } } Which when dropped...

I appreciate that Colin...but the JSON data is full of confidential information....yes, it's just the OrderID info I need. Ebay have two APIs ...legacy API which uses XML (& contains Legacy OrderIDs - which I've always used to date) & their new REST API which uses JSON (and contains Ebay's...

Thanks...yes, that approach is very XML-esque (which I find painful ...JSON was meant to make things less ugly to pick the bones out of!) I've managed to workaround, but it's a real kludge (which I excel in!), but until I'm more JSON Savvy it'll get me away... Basically I search for a unique...

I'm trying to parse a bit of JSON like this... ...I'm interested in orderIDs (50 of them) ......the path to this field is showing at the top of the jpg. I've clearly got my code set wrong, as after 6 loops it exits (if you look at the top of the jpg there are 6 objects), so I need to set...

A relatively simple solution was found via this link. https://bytes.com/topic/access/answers/923353-preventing-control-losing-focus "I added an invisible control to the form and made it next in the tab order after my input text box. Under the "On Got Focus" of this control i made it return the...

Sure, my main form has a field called ScannedBarcode ....I have set 'AfterUpdate' to run this VBA... Private Sub ScannedBarcode_AfterUpdate() Dim wavfile As String If Not IsNumeric(ScannedBarcode) Then Call PlayWav("C:\AccessData\audio\", "scan_error.wav") MsgBox "You didn't scan a...