Re: Intl address progress -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.