Re: Intl address progress

On 8/1/2024 1:01 PM, John Yeung wrote:

On Thu, Aug 1, 2024 at 11:47 AM Art Tostaine, Jr. <atostaine@xxxxxxxxx>

wrote:

If it helps describe what I'm trying to do we receive JSON and write the
data to IBM i tables. Then we need to create a CSV for international

labels

to import in Fedex shipping program.

Sorry, but this *screams* to be handled via the PASE open source
technologies IBM has provided. What you describe sounds like something
that is stupidly easy in Python.

As a strictly amateur Python-er, I would think that
requests - for the web side; retrieving the JSON and delivering the csv
JSON - to convert the JSON to a dict
csv - to consume the dict and write rows to the csv file

How would those be as search terms for someone interested in a Python
solution? I worry that I have ancient memories and thus am totally
missing out on a modern, Pythonic way to do this.

The SQL solution is an interesting proposal. Our SQL can do HTTP stuff,
decode the JSON, and write stream files. I'd think that making the csv
columns wouldn't be too hard, but I expect this is more nitty-gritty
than Python would be.

--
--buck

http://wiki.midrange.com
Your updates make it better!


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.