ExportAppointments

Exports appointments for one or all users. In case you export appointments for all users of your organization, the number of rows to export must not exceed 100,000. Otherwise the export will fail.

GET
https://my.portatour.net/a/api/ExportAppointments?parameters
Required URL parameters
formatExport format, can be one of xlsx, xls, ods, csv, simplecsv, or xlsxtable. More information
Optional URL parameters
languageRecommended. Language used for the export. More information
userEmail,
employeeNumber
Email address or employee number of the user whose appointments to export. Only one may be specified. If neither userEmail nor employeeNumber is specified, appointments for all users will be exported.
includePastIf set to true the export includes appointments that are in the past. Default is false.
exportFieldsIf specified, the export will only contain the listed fields, in the specified order. More information
Example usage with curl
curl -o appointments.csv -u admin_username:admin_password "https://my.portatour.net/a/api/ExportAppointments?format=csv&language=en-US&userEmail=bob@example.com"

Caution: When you process exported data, don't depend on the column order. Use the column header names to access data. The order of the columns might change, e.g if new fields are added. In case your importer doesn’t support accessing field values by field name, use the exportFields parameter to specify the columns and their order.

Refreshing offline data
Loading...