Reading about the Metadata API, it looks like you have to
- download something special (the WSC?), and
- use Java
To query data from Salesforce tables, I could easily use Python, make HTTP requests with
requests library, make a SOQL query, and it worked.
But to make a new table for some new custom object, I'm finding out I need the Metadata API, and for the Metadata API there's the extra hassle of either using some GUI, or needing the WSC and having to use a certain language.
So I'm not sure how I'd, for example, deploy a script somewhere which creates a custom Salesforce table to load data into.
Is what I'm doing, and assuming, correct? If so, can one not deploy code to some machine elsewhere and have it be able to create custom Salesforce tables?