Feb-14-2022, 11:34 PM
Hi, new poster here! Been working with Excel, VBA and PowerQuery for a few years now and really wondered what's all the fuss about Python. I work a lot with REST-based API-s as a data consumer/analyst (HTTP GET/POST calls). But looks like I'm stuck with a particular API and apparently time has come to widen my toolbox since I have run out of functionality with my previous stack.
I need to connect to a REST-based API and get a ISO 20022 XML format data back - would work just fine with Excel / PowerQuery, however - the API uses x.509 certificate based authentication which PowerQuery / Excel VBA cannot do.
Is this something Python could comfortably handle? I'm really taking my very first steps in Python world, so any guidance, code samples or relevant blog posts etc would be greatly appreciated!
I need to connect to a REST-based API and get a ISO 20022 XML format data back - would work just fine with Excel / PowerQuery, however - the API uses x.509 certificate based authentication which PowerQuery / Excel VBA cannot do.
Is this something Python could comfortably handle? I'm really taking my very first steps in Python world, so any guidance, code samples or relevant blog posts etc would be greatly appreciated!