Thanks. I forgot to come back here and delete my post. I had a brain fart. Post was allowed on the CF server instead of the Woocommerce site's webserver.  ... View more

The .bat file only updates the password. The user ID is manually edited in the neo-security.xml file.  ... View more

Charlie, Run as administrator did the trick.   Thanks! ... View more

Just saw this response. Thanks! I will try it. ... View more

Charlie, I downloaded jsoup and tried the sample code from the example it and just runs until it eventually times out. <!--- cache it to speed it up ---> <cfif not cacheIdExists("cnnhtml")> <cfhttp url="http://www.cnn.com"> <cfset cnnhtml = cfhttp.filecontent> <cfset cachePut("cnnhtml",cnnhtml)> <cfelse> <cfset cnnhtml = cacheGet("cnnhtml")> </cfif> <cfscript> jsoup = createObject("java", "org.jsoup.Jsoup"); doc = jsoup.parse(cnnhtml); links = doc.select("img"); </cfscript> <cfdump var="#variables#" abort /> <cfloop index="e" array="#links#"> <cfoutput> #e.attr("src")# --- Title: #e.attr("title")# --- Alt: #e.attr("alt")#<br/> </cfoutput> </cfloop> Did I miss something? Gary  ... View more

I'm going to try it tomorrow and I'll report back how it goes and mark the answer then. ... View more

Thanks Charlie. I'm going to play with jsoup. Looks like a fun approach. ... View more

Thank you! This is something I've had on the back burner for years to save our fulfilment team the task of double data entry between our portal and UPS. We've used the UPS API before but after writing all the code they dumped the particular platform we were using for a more secure method. A few days ago I stumbled upon the Shippo API which allows you to compare multiple carriers, print the label then uses webhooks to update the status and delivery. Way more functionality than UPS and easier to work with.   G ... View more

Thanks Charlie. ArrayIsDefined works perfect! ... View more

Charlie, We have about 4000 devices in the field that check in every 5 seconds and another 10,000 devices that check in every hour. Then add the rest of our traffic and I estimate around 1100 per second. I didn't look at Fusion for an exact count. We're adding load balaning this weekend to split the traffic between our two datacenters.  PS - sent you an email yesterday to try and get on your schedule to look at this.  ... View more

Thanks. Just need the temp fix while we dig into what is going on. We can see that traffic has increased to about 1100 transactions a second but as you mentioned there likely is more to the story. ... View more

Take a look at: https://github.com/Gary-Hanna/Stripe-Coldfusion-API It will at least give you a start at how the Stripe API works.     ... View more

Look here:  https://github.com/Gary-Hanna/Stripe-Coldfusion-API   Let me know if you need any help. ... View more

BKBK, I appreciate your response. You are always helpful. In this case, however, you are partially correct. Yes, metadata would have fixed the issue in 2016 but is not needed in 2018 or 2021.   "To reiterate, the error does not originate from the struct stFields. It originates from squareupdata, the output of a cfhttp post. But we don't know the contents of squareupdata. So the original question is moot."   As I said above the issue is in stFields, not SquareUpData. SquareUpData is the response data from Square. You do not post SquareUpData it is a read only response. You post stFields and Square responds with a check_out URL in SquareUpData unless there is an error and then Square responds with the error in SquareUpData. The field order.Total_Money_Amount is a read-only field calculated by Square based on the fields in order.line_items.quantity and order.line_items.amount. Quantity and amount need to be integers. If Square can't read quantity and amount then the total order amount is less than 1 and Square responds in SquareUpData what the error is. ... View more

I have updated to 2021.  I appreciate your help though. For the next person reading this... 1) The field order.total_money_amount is actually a read-only field that Square calculates in the response. It is based on you sending order.amount and order.quantity. You don't send total_money in the request. 2) SquareUpData is the response data, not the data you send. Here's an example of working code: <cfset REQUEST.location_id = "YourLocationID"> <cfset REQUEST.Access_Token = "YourToken"> <cfset REQUEST.Square_Server = "connect.squareup.com"> <cfset REQUEST.Square_Version = "2020-12-16"> <cfif StructKeyExists(Session, "total") AND StructKeyExists(Session, "CustomerID")> <cfset session.total = session.total * 100 /> <cfset REQUEST.Amount = #session.total#> <cfif isDefined("URL.transactionId")> <cfset rtFields = { "order_ids": [ "#URL.orderID#" ] }> <cfhttp method="post" result="objGet" url="https://#REQUEST.Square_Server#/v2/locations/#REQUEST.location_id#/orders/batch-retrieve"> <cfhttpparam type="header" name="Accept" value="application/json"> <cfhttpparam type="header" name="Authorization" value="Bearer #REQUEST.Access_Token#"> <cfhttpparam type="header" name="Cache-Control" value="no-cache"> <cfhttpparam type="header" name="Content-Type" value="application/json"> <cfhttpparam type="body" value="#serializeJSON(rtFields)#"> </cfhttp> <cfelse> <cfset REQUEST.Base_Price_Money_Amount = #session.total#> <cfset REQUEST.idempotency_key = #CreateUUID()#> <cfset REQUEST.order_idempotency_key = #CreateUUID()#> <cfset stFields = { "idempotency_key": "#REQUEST.idempotency_key#", "order": { "idempotency_key": "REQUEST.order_idempotency_key", "order": { "location_id": "#session.REQUEST_LocationID", "customer_id": "C-#session.CustomerID#", "line_items": [ { "quantity": '1', "name": "Item Name", "note": "Any Item Note", "uid": "uid", "base_price_money": { "amount": int(#REQUEST.Base_Price_Money_Amount#), "currency": "USD" } } ] } }, "ask_for_shipping_address": false, "merchant_support_email": "CustomerService@example.com", "redirect_url": "https://someURL.com/SquareOrderComplete.cfm" }> <cfhttp method="post" result="objGet" url="https://#REQUEST.Square_Server#/v2/locations/#REQUEST.location_id#/checkouts"> <cfhttpparam type="header" name="Square-Version" value="#REQUEST.Square_Version#"> <cfhttpparam type="header" name="Authorization" value="Bearer #REQUEST.Access_Token#"> <cfhttpparam type="header" name="Content-Type" value="application/json"> <cfhttpparam type="body" value="#serializeJSON(stFields)#"> </cfhttp> </cfif> <cfscript> squareupdata = deserializeJSON(#objGet.FileContent#); </cfscript> 3) If using CF2016 you need to add the metadata above in BKBK's post. You don't need it in 2018 and 2021. 4) Square checkout (unlike Stripe) after the customer completes the checkout does not return JSON. The customer can't get to the order complete page until the card has been approved. You get ID's for reference in the order complete URL.   ... View more

Square uses the lowest common denominator of any currency. So in the US, that's a penny. Sending 1 equals $0.01 where sending 100 equals $1.00. The issue was in CF 2016 when serializing the JSON CF wasn't sending the amounts as integers even if you wrapped it as INT(#value#).  In CF2018 and CF2021 serializing the JSON created the value as an integer and Square was happy. We tested the exact same code in 2016, 2018, and 2021. It failed in 2016 and worked perfectly in the newer versions. ... View more

It seems the issue was how CF2016 processes the JSON. The exact same code works in CF2021. ... View more

Might not be the best way to do it but this worked to simply remove the # for the JSON results: <cfset content = replace(#cfhttp.filecontent#, "##", "", "all") /> <cfset results = deserializeJSON(content) />   ... View more

I tried your suggestion: <cfif Isdefined("results.track.album.image[2]['#text']")> do something </cfif> and still got: An expression that began on line 26, column 48. The expression might be missing an ending #, for example, #expr instead of #expr#. An expression beginning with /", on line 26, column 17.This message is usually caused by a problem in the expressions structure. An expression beginning with Isdefined, on line 26, column 7.This message is usually caused by a problem in the expressions structure. A cfif tag beginning on line 26, column 2. ... View more

BKBK, Thanks for going through all that effort! I really appreciate it. I must have fat-fingered something the first time I tried your example. I also got it to work late last night using:  <cfexecute name="d:\lame\lame.exe" arguments="-b 128 ""d:\lame\ABBA - Dancing Queen.mp3"" ""d:\lame\Abba - Dancing Queen128.mp3""" />   Appreciate everyone's help!   Gary ... View more

Lame.exe only requires quotation marks if there are spaces in the input or output file. For a test, I renamed the input file to queen.mp3 and the output file to queen128.mp3. I ran the command line as: lame -b 128 queen.mp3 queen128.mp3 which worked as expected. I tried the same argument without quotes in CF and it works. So it's something wrong in how we're creating the argument with quotation marks.  <cfexecute name="d:\lame\lame.exe" arguments="-b 128 d:\lame\queen.mp3 d:\lame\queen128.mp3">     ... View more

Thanks for the suggestions. I tried BKBK's: <cfexecute name="d:\lame\lame.exe" arguments='-b 128 "d:\lame\Abba - Dancing Queen.mp3" "d:\lame\Abba - Dancing Queen 128.mp3"' I also tried adding timeout as Charlie suggested. <cfexecute name="d:\lame\lame.exe" arguments='-b 128 "d:\lame\Abba - Dancing Queen.mp3" "d:\lame\Abba - Dancing Queen 128.mp3"' timeout = "20" outputFile = "D:\lame\output.txt"> I also tried Charlie's suggestion of running CMD: <cfexecute name="c:\windows\system32\cmd.exe" arguments='/c d:\lame\lame.exe -b 128 "Abba - Dancing Queen.mp3" "Abba - Dancing Queen 128.mp3" ' timeout = "20" outputFile = "D:\lame\output.txt"> Still no luck. Even if the arguments are wrong Lame.exe returns something. If CF is launching the exe shouldn't I see something besides an empty output.txt file created? I thought it would capture whatever lame.exe outputted.    Gary ... View more