ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData Excel Add-In for Xero ビュー
Name | Description |
EmployeeBankAccounts | Query the bank accounts for an Employee in a Xero organisation. |
EmployeePayTemplateDeductions | Query the pay template deduction lines for an Employee in a Xero organisation. |
EmployeePayTemplateEarnings | Query the pay template earnings lines for an Employee in a Xero organisation. |
EmployeePayTemplateLeave | Query the pay template leave lines for an Employee in a Xero organisation. |
EmployeePayTemplateReimbursements | Query the pay template reimbursement lines for an Employee in a Xero organisation. |
EmployeePayTemplateSupers | Query the pay template super lines for an Employee in a Xero organisation. |
LeaveBalances | Query the Leave Balance for an Employee in a Xero organisation. |
PaySlipLeaveEarnings | Query payslip leave earnings line-items for a Xero organisation. |
PaySlips | Query payslips for a Xero organisation. |
Tenants | Query the list of organisations connected to your Xero account. |