I'm working on making some Python scripts at work which make use of client's APIs. These APIs are reporting data which is highly segmented by ID relations.
What app or Python-related toolset could I use to import API resource addresses and map their relations in an Entity Relation Diagram (ERD)?
At work I'm on Windows 10 and at home I use Linux. I'm using Python in my scripting, but I don't need this software to provide any material resources for this effort.
I'm testing the connections with
curl, and browsing the data with Excel PowerQuery. Again, it's hard to make any sense out of the raw table data in Excel. Short of someone just telling me which API's contain what data I need to join to create the table I require, I need some method to understand the relationships. With an ERD-view I can reason and determine the tables I could create.
Database Entity Diagrams from Existing Database, but then add relationships for documentation only (Recommended software does not mention API support)
Software for mapping an API or information system (No answers here)