The private key from the .pem file that was generated for your Xero private application, see Create a public/private key pair. Note to generate the privatekey.pem with numbits of 512 using openssl genrsa -out privatekey.pem 512; 1024 is not supported. Include all the text from the .pem file including the Unix line endings(\n), see sample below.

Tables with complex items will be split to multiple tables. For example, Bank transactions has a complex data structure "LineItems", so data of bank transaction is mapped to table Bank_Transaction and Bank_Transaction_Line_Items, with Bank_Transaction_ID as foreign key to link them together.

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.

The following tables have the same information in the Minimal and Complete schema. To reduce the number of API calls, use Minimal schema (default).