[Ftpapi] Odd Error Code Perhaps One of You Can Help

From: John Place <john.place@xxxxxxxxxxxxxxx>

To: "'FTPAPI/HTTPAPI mailing list'" <ftpapi@xxxxxxxxxxxxxxxxxxxxxx>

Subject: [Ftpapi] Odd Error Code Perhaps One of You Can Help

Date: Tue, 17 Nov 2020 17:49:52 +0000

I keep getting an odd error code and I cant determine what I’m doing wrong, here is the code to get the data:

I send the DataLine to an IFS file so I can capture the output of the regular _expression_ just to visualize what I’m getting, regarding the regular _expression_ I have do this in order to parse the JSON file and this works just fine if I capture the file into an IFS file then use Grep to remove the part of the JSON that causes the error, however when I capture just the output to a variable is when the error occurs, I have a feeling its being caused by the regular _expression_ however the DataLine variable looks identical to the file I produce using Grep.

This is where the error occurs:

Thoughts?

Keeping in mind this works….

Thank You,
John Place

284 Fuel Supply LLC
General Manager
Direct Line: 563-468-5289
Cell: 563-529-0162
Email: John.Place@xxxxxxxxxxxxxxx

Notice: Any agreement discussed or implied in this message is for discussion purposes only and may not be relied upon to bind the company. Agreements are binding only when fully committed to writing and executed by authorized representatives of all the parties. The information contained herein, while provided in good faith and believed to be accurate, is provided by 284 Fuel Supply, LLC and or Iowa 80 Group, Inc. and their affiliates as an accommodation to their readers for information purposes only, it is not guaranteed as to accuracy or completeness. The information contained in this communication is confidential and is intended only for the use of the addressee. It is solely the property of 284 Fuel Supply and or Iowa 80 Group Inc. and their affiliates. Unauthorized use of this information, in whole or in part, is strictly prohibited. If you have received this communication in error, please notify us immediately by return e-mail and destroy this communication, including all attachments and any copies.

[ { "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPAREL0W4N0SP002P","Status":"0","TickerSymbol":"FSPAREL0W4N0SP002P","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3188" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0WAR0SR007N","Status":"0","TickerSymbol":"FSPARFT0WAR0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.2984" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0WEL0SR007N","Status":"0","TickerSymbol":"FSPARFT0WEL0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"9" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0WHK0SR007N","Status":"0","TickerSymbol":"FSPARFT0WHK0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4135" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARFT0W4C0SR007N","Status":"0","TickerSymbol":"FSPARFT0W4C0SR007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3465" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WAR0SV007O","Status":"0","TickerSymbol":"FSPARLR0WAR0SV007O","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3313" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WAR0SX004G","Status":"0","TickerSymbol":"FSPARLR0WAR0SX004G","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3354" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SU0028","Status":"0","TickerSymbol":"FSPARLR0WEL0SU0028","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SV007O","Status":"0","TickerSymbol":"FSPARLR0WEL0SV007O","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SW007P","Status":"0","TickerSymbol":"FSPARLR0WEL0SW007P","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL0SX004G","Status":"0","TickerSymbol":"FSPARLR0WEL0SX004G","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"9" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0WEL26O000B","Status":"0","TickerSymbol":"FSPARLR0WEL26O000B","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-05-07","PrdEffectiveTime":"781","Last":"9.02" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4C0SU0028","Status":"0","TickerSymbol":"FSPARLR0W4C0SU0028","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.368" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4N0ST008P","Status":"0","TickerSymbol":"FSPARLR0W4N0ST008P","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3875" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4N0SU0028","Status":"0","TickerSymbol":"FSPARLR0W4N0SU0028","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.5231" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPARLR0W4N0SX004G","Status":"0","TickerSymbol":"FSPARLR0W4N0SX004G","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4001" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEBXHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEBXHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4568" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEBYHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEBYHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4603" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8AR0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8AR0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3856" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8CD0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8CD0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-04-01","PrdEffectiveTime":"1080","Last":"9.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8CD0ZL0HA4","Status":"0","TickerSymbol":"FSPIABEB8CD0ZL0HA4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-17","PrdEffectiveTime":"0","Last":"6.3914" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8GZ0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8GZ0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4133" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8HK0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB8HK0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-10-01","PrdEffectiveTime":"1080","Last":"8.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8HK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEB8HK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4866" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB8330ZI0006","Status":"0","TickerSymbol":"FSPIABEB8330ZI0006","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4459" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB84C0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB84C0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4094" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9AR0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9AR0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.3891" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9CD0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9CD0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-04-01","PrdEffectiveTime":"1080","Last":"9.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9CD0ZL0HA4","Status":"0","TickerSymbol":"FSPIABEB9CD0ZL0HA4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-17","PrdEffectiveTime":"0","Last":"6.3964" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9GZ0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9GZ0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4168" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9HK0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB9HK0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-10-01","PrdEffectiveTime":"1080","Last":"8.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9HK0ZL00A4","Status":"0","TickerSymbol":"FSPIABEB9HK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4901" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB9330ZI0006","Status":"0","TickerSymbol":"FSPIABEB9330ZI0006","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4509" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABEB94C0ZJ007N","Status":"0","TickerSymbol":"FSPIABEB94C0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4129" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABECMHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABECMHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4484" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABECNHK0ZL00A4","Status":"0","TickerSymbol":"FSPIABECNHK0ZL00A4","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.4272" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SAR0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SAR0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.2883" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SCD0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SCD0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-04-01","PrdEffectiveTime":"1080","Last":"9.9999" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SGZ0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SGZ0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-11-16","PrdEffectiveTime":"1080","Last":"1.2962" }},{ "Attr":{ "Market":"406","MarketName":"PRD","RequestedSymbol":"FSPIABE0SHK0ZJ007N","Status":"0","TickerSymbol":"FSPIABE0SHK0ZJ007N","Vendor":"DTN" }, "Data":{ "PrdEffectiveDate":"2020-10-01","PrdEffectiveTime":"1080","Last":"8.9999" }} ]

-- _______________________________________________ Ftpapi mailing list Ftpapi@xxxxxxxxxxxxxxxxxxxxxx http://scottklement.com/mailman/listinfo/ftpapi