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.