Thank you Tim Rodman for the feedback on using Odata to access. I found the excel exports would produce errors in python pandas.
I am exploring options, and found that C# has much better Odata support than Python, due to Odata being under the MS Umbrella, so it seems likely that I will go ahead with using C#
This template looked to be very helpful in creating a Odata Consumer and I look to adapt this into a Odata Consumer that I can use as the first Extract step of an ETL pipeline.
AspNetOdata/ConsoleConsumer at master · stevsharp/AspNetOdata (github.com)
Am I reinventing the wheel here? Has anyone else used C# to get data out of Acumatica?
