Search results

Just to help anyone else out here (who may find this thread at a later date via google etc.) here's some code that shows how to request all your Shopify products as a JSON API call using VBA ... Set XMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0") XMLHTTP.Open "GET"...

Many thanks to the DBGuy ...sterling input there :-) Just in case anyone is trying to use the above code with the supplied key/secret I've now deleted on my test site keys as I've now imported some live/personal data

Wow...thanks....that's it! Their API server returned... {"orders":[]} (just like the manual URL did) How did you come up with this bit... ZDY2MTVjZjEyZWEwNGM5NTdhNDcwYzVkMThkNTBhNTI6c2hwcGFfMjk1NjcxNmYwYjI4YzU3YzYyZWQ0MmRjOTRhYjcxNmU= vs the Username(API Key) of...

I've kludged together a lot of my own APIs (interfacing with Ebay etc), but they weren't REST type APIs (which is what the Shopify API here is)... additionally, I was able to source sample VBA code from all over the web towards getting an end result I needed ...but I've never managed to get off...

I guess that's what I'm seeking ...i.e. how to construct that supplied URL as an HTTP Get request in VBA, specifically using these bits in red... XMLHTTP.Open "GET", strLogin XMLHTTP.setRequestHeader "Content-Type", "text/xml" XMLHTTP.send I don't understand sufficiently about the...

Yes, I got a load of verbose stuff back, but I don't think it's right (which suggests my API call was wrongly constructed) - what I would be expecting back (if the API call was constructed correctly) would be something like seen when manually typing this URL...

They have this... https://shopify.dev/docs/admin-api/rest/reference and also this https://shopify.dev/tutorials/make-your-first-shopify-api-request ...which is a lot of reading. My problem is just getting off the ground with the right 'call', e.g.... Set XMLHTTP =...

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...

Thanks...I fixed it by using the decimal data type for the table fields .....my calculations now end up as result of 0 vs. the whacky number!

Edit: I thought I'd sorted this but spoke to soon ...the problem is still there

So I have a problem where an e table is throwing up some whacky numbers In my access table I have configured as "doubles" The ShippingTotal field is calculated by a basic formula .... ShippingNet + ShippingTax - ShippingDiscountNet - ShippingTaxDiscount in the access table it all looks...

It's because I created a new test query to have a dabble/ play with (without messing up my original working query)...when I copied in some SQL, the semi-colon came in with it To be clear the Union query work (with or without the semi colon)...it's just a bit annoying to have the popup showing...

I appreciate your input - I'm a little out my depth here (new to UNION queries). here's what I did... I constructed 1 query (which had all the items sold)...it has filters I duplicated that query )s that it would be a replica of query 1) & then modified just for the shipping cost...I had to...

Thanks ...you went above & beyond there....the csv template file I downloaded had the * in...but I've just removed them as a trial & the import to Xero still works (so they aren't necessary), however Access still protests (albeit with a different error message now the * are removed)... I'll...

All the data for my union query is sourced from another query (a query called OrdersFBM__processed_and_shipped). The Order date info in that source query is called OrderDate - the target app that I'm exporting to requires the csv field to be named *InvoiceDate hence that line you've asked...

thank you :)(y) I have one issue...if I drop each 'chunk' of SQL into a standalone query (not union)...each individual query runs fine. When I do the union query & run it I get popup... ...when I click on OK, everythingthen runs fine Any ideas? (to be clear *InvoiceNumber is the field...

That worked a charm (y) ....that said I couldn't get the 'GROUP BY' to work ..Access reported extra characters at the end of the SQL? (my SQL is actually a lot uglier on the eye ....as I'd simplified my opening post just to make it easier to ask the question! Here's my SQL... SELECT...

I have a query sourced from several Access tables that gets exported like this... the problem is Xero (an accounts app), won't accept the shipping cost on the same row, but needs it to be broken out onto its own dedicated row, like this... my question is what would be the most efficient...

Thanks for the input (& the welcome back) It transpires that (since Saturday) Ebay are now adding this unique code to shipping address labels (to help assist with Item Not Received claims...how thgis helps I have no idea!)...I've no issue with this unique reference going on the generated...

Many thanks...you've been of great help :-)