<>#v } 73SHOPORD1 - GET SHOPIFY LIST FROM API COMBINE WITH 3PLC 3created from SHOPGET0 (2$D<U$$M4SHOPORDS,4.tpl15,4 E5n@@x5$C Ө%Y-%Mz-%DzT01:01:01-06:00($/admin/orders.json?page=۩(D$#% CREATESHOPNUMBER TOPIC.$FILENAME(3 get list of open orderid from shopify3 query list in 3PLCD3query shopify for full order info - create new 3PLC order if needed 3show status4<$4/admin/orders.json?fields=id,order_number,created_atH"GETSHOPGET\$NPaA$O '.orders[۩(N$] | .id, .created_at, .order_number'fJQ1O1p 1+ Ff1:c(1*),f2:c(1*),f3:c(1*)$F1* @H@Hnull&$@G@H@I@L@K@J" LME$PP۩@L,$NNa3------- GET 3PLC RESULTS `$@/orders?rql=ReadOnly.CustomerIdentifier.Id==12;ReferenceNum=in=(PP) "GET3PLCGETQR V$N `H$O'.ResourceList[۩(N%] | .ReadOnly.OrderId, .ReferenceNum' JQ1QO1 9 Ff1:c(1*),f2:c(1*),f3:c(1*)$F1" * @H@Hnull ( %$SA@J1MS E $@T@H LME $NN  ` (3 -3--------- SHOW TABLE OF SHOPIFY OPEN ORDERS $$ .id, .email, .created_at, .number, .order_number, .fulfillment_status, .line_items[0].title, .line_items[0].sku, .fulfillments[0].tracking_company, .fulfillments[0].tracking_number, .fulfillments[0].shipment_status, .wms_orderidBorders $9,$ 4X9$;;f۩(X:c(1*),*X  <;; $ 1

Open Shopify Orders

[
۫ $6& $/admin/orders.json "GETSHOPGETUV $N 0+$O '.orders[۩(N] | $' :JQ1UOW D/$<W"<<null N @=@=null X*$@YA@Y @Y 2019-02-18t  E E$ZA@e 1MZ E $@[@T  @[ H e3 IF CVS(REC.F10$,3)="" THEN GOTO 3400; REM no tracking yet onl;y need this line for shopify shipping $_VCreate WMS Order  @[$@[_ H3------ ALL SET DISPLAY &$ ',۫< %&t$NN 0<3doneP$ 
#(3----------- DISPLAY ITEMS /orders$$ .id, .email, .created_at, .number, .order_number, .fulfillment_status, .line_items[0].title, .line_items[0].sku, .fulfillments[0].tracking_company, .fulfillments[0].tracking_number, .fulfillments[0].shipment_statusBorders$ 

#

@[
۫ $6&"$9,$;4:9$;;f۩(: :c(1*=10),*: <;;$$(h $rH$*$,*&1|1*B?*  $' ,$.echo '' | jq '$' 2>&1#U $-1"7$<- URI customersg$7 select as active, /items?ᫀ URI @$@?>&$-<+- -Ө- $---0"$--73ADD SOME ACTION COLS\&$ ',۫- %&f$(h3$$ 
~#(#3----------- CALL CREATE WMS ORDER$$`Aӫ CREATESHOPNUMBER($ CREATE ۫ CREATESHOPNUMBER1M`E SHOPDOG1`abcdP>$ 
SHOPIFY ORDER
Z&JQHTMLaf$ fnC$ $
3PL CENTRAL ORDER
x&JQHTMLcf$ ffX3debug]$ 

b$ 

@3errorJ=$+error ۩(Ө at line ۩(Ө" in ۩#E2#(3#<($*$,*1*LK?*#F$ >
RAW RESULTS




#P$ ۫||| #Z63show paths#&3done'310000 "functions'3string$, token$, delimiter$'$'.$'8'$ 'V'B&$ܨ$'L $'V 8'`]'j 't>$ - $'~ $'a$3IF LEN(Y1$) THEN IF Y1$(LEN(Y1$))="." THEN LET Y1$=Y1$(1,LEN(Y1$)-1); GOTO 10122' 8']'';$"":  $(' $'$Ө'$},( $($ө(8(])`3---- this function loads a template with fields names that macth the xml fragment that is sent)  )  ) !$  3SET TO UPPERCASE)$ ө ,)/ N[۩( ]:c(32*)$ )"  ),$ @@)6"V @@ )^*)8 )].3 webhook for orders/create/$n$,nIO/1nB?/o/n/D$gchuck@tssconnect.comi"Dogist Webhook orders/create alertjWebhook was received

"
۩ "/N$ Webhook processed/b$jj
o
/,WHMAILTOghijklmd02U 36$13@<$/'WFDIR tmp/3plget0_۩(Өө.json3J $0. > / 2>&13T(3A=SCALL("echo -e ""\n\n"" >>"+OUTFILE$)3^$$,/33^10031B?133^10034N86&3"get all paths from the json in out2$6*$./usr/local/bin/jq_getpaths.sh 6261$ A
7 8@3------ LINK TO STOCKDETAILS@[ @\NAB001$][ASN@8J  21$32 .33.
$33_
$33,)83] $ ($ܨ8]  $$!$!ө"8!&]d i4$ өȴ$ȴn>$$Өȴ8Ⱦ] * $ z4$($ܨz8]$ $ b&$0$: $b8g]  2$22?%3f$22&%26@82J]Y1Y2Y3Y0PY1Y2YYYYYZ1TPLZ2Z1FCOUNTFLISTFLOOPFINFO FLIST.NTLEN FINFO.LLYYY1YYY2YYYYYTAGYYVALYY1YYY0YYY1OUT1OUT2CIURITEXTYYYVCGIURI1COLSTDDTROTRLTDDCJ ERRMESSAGETDL2 MYSCALL1OUTFILEAOUT3ZZZZZFTPLCOLS2L22WFCGI1FFFF1FTPLREC REC.F1 STOCKDETAILS REC.F2 PAGEMENUMYSCALLARRAY FROMDATEPAGE SHOPORDSR SHOPORDS.ID R.F1 SHOPORDS.NUMBER R.F2 SHOPORDS.CREATED_AT R.F3 SHOPORDSJROWJFILTERREFSWMS1WMS2REF1 SHOPORDS.WMSORDERIDOUT11OUT22OUT33F REC.F3 SHOPNUMBER REC.F12 JBLHD.CUSTNABLINKJBLHDWMSLINKSHOPNUMSHOPREC WMSORDERIDWMSRECRESULT REC.F5TEXT1SENDTOCCTOSUBJECTMESSAGE SIGNATURE HTMLFILEXLFILESTDININBLOCKGETXSUBFI1FILLXCOUNTELEMENTSD8TOJSETXGETGCGIVALDOSCALLCOLHEADURI*