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.
|
https://my.portatour.net/a/api/ExportAppointments?parameters
|
| Required URL parameters | |
| format | Export format, can be one of xlsx, xls, ods, csv, simplecsv, or xlsxtable. |
|---|---|
| Optional URL parameters | |
| language | Recommended. Language used for the export. |
| measurementSystem | Recommended. Measurement system used for the export. |
| 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. |
| includePast | If set to true the export includes appointments that are in the past. An appointment is considered to be in the past, if its LatestEnd is earlier than today. Default is false. |
| exportFields | If specified, the export will only contain the listed fields, in the specified order. More information |
|
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.