I copied data from Xero api to mySQL database using the Xero connector in Azure data factory. However, The copied data did not contain all the data columns. I read in a documentation that Xero data is available through two schemas: Minimal (default) and Complete. The Complete schema contains prerequisite call tables which require additional data (e.g. ID column) before making the desired query. My question is, How do we import the complete schema in Azure data factory?
The minimal schema has Account code and not account ID in the invoice table. I need the Account ID to import account related data and I believe that the complete schema will have it. Could someone please help with this.