Column identifiers deprecated
Below you find the identifiers for object fields of certain data objects (models) that can be used in the columns parameter of a request to return
specific field data of single or multiple objects.
Common object data
| ID |
Name |
| 1 |
id |
| 2 |
created_by |
| 3 |
modified_by |
| 4 |
creation_date |
| 5 |
last_modified |
| 20 |
folder_id |
| 100 |
categories |
| 101 |
private_flag |
| 102 |
color_label |
| 104 |
number_of_attachments |
| 105 |
lastModifiedOfNewestAttachmentUTC |
Common folder data
| ID |
Name |
| 1 |
id |
| 2 |
created_by |
| 3 |
modified_by |
| 4 |
creation_date |
| 5 |
last_modified |
| 6 |
last_modified_utc |
| 20 |
folder_id |
Detailed folder data
| ID |
Name |
| 300 |
title |
| 301 |
module |
| 302 |
type |
| 304 |
subfolders |
| 305 |
own_rights |
| 306 |
permissions |
| 307 |
summary |
| 308 |
standard_folder |
| 309 |
total |
| 310 |
new |
| 311 |
unread |
| 312 |
deleted |
| 313 |
capabilities |
| 314 |
subscribed |
| 315 |
subscr_subflds |
| 316 |
standard_folder_type |
| 317 |
supported_capabilities |
| 318 |
account_id |
| 3010 |
com.openexchange.publish.publicationFlag |
| 3020 |
com.openexchange.subscribe.subscriptionFlag |
| 3030 |
com.openexchange.folderstorage.displayName |
| 3060 |
com.openexchange.share.extendedPermissions |
Detailed task and appointment data
| ID |
Name |
| 200 |
title |
| 201 |
start_date |
| 202 |
end_date |
| 203 |
note |
| 204 |
alarm |
| 209 |
recurrence_type |
| 212 |
days |
| 213 |
day_in_month |
| 214 |
month |
| 215 |
interval |
| 216 |
until |
| 217 |
notification |
| 220 |
participants |
| 221 |
users |
| 222 |
occurrences |
| 223 |
uid |
| 224 |
organizer |
| 225 |
sequence |
| 226 |
confirmations |
| 227 |
organizerId |
| 228 |
principal |
| 229 |
principalId |
| 401 |
full_time |
Detailed task data
| ID |
Name |
| 300 |
status |
| 301 |
percent_completed |
| 302 |
actual_costs |
| 303 |
actual_duration |
| 304 |
after_complete |
| 305 |
billing_information |
| 307 |
target_costs |
| 308 |
target_duration |
| 309 |
priority |
| 312 |
currency |
| 313 |
trip_meter |
| 314 |
companies |
| 315 |
date_completed |
| 316 |
start_time |
| 317 |
end_time |
| ID |
Name |
CSV column title |
| 223 |
uid |
|
| 500 |
display_name |
Display name |
| 501 |
first_name |
Given name |
| 502 |
last_name |
Sur name |
| 503 |
second_name |
Middle name |
| 504 |
suffix |
Suffix |
| 505 |
title |
Title |
| 506 |
street_home |
Street home |
| 507 |
postal_code_home |
Postal code home |
| 508 |
city_home |
City home |
| 509 |
state_home |
State home |
| 510 |
country_home |
Country home |
| 511 |
birthday |
Birthday |
| 512 |
martial_status |
Martial status |
| 513 |
number_of_children |
Number of children |
| 514 |
profession |
Profession |
| 515 |
nickname |
Nickname |
| 516 |
spouse_name |
Spouse name |
| 517 |
anniversary |
Anniversary |
| 518 |
note |
Note |
| 519 |
department |
Department |
| 520 |
position |
Position |
| 521 |
employee_type |
Employee type |
| 522 |
room_number |
Room number |
| 523 |
street_business |
Street business |
| 524 |
user_id |
Internal user id |
| 525 |
postal_code_business |
Postal code business |
| 526 |
city_business |
City business |
| 527 |
state_business |
State business |
| 528 |
country_business |
Country business |
| 529 |
number_of_employees |
Number of employee |
| 530 |
sales_volume |
Sales volume |
| 531 |
tax_id |
Tax id |
| 532 |
commercial_register |
Commercial register |
| 533 |
branches |
Branches |
| 534 |
business_category |
Business category |
| 535 |
info |
Info |
| 536 |
manager_name |
Manager's name |
| 537 |
assistant_name |
Assistant's name |
| 538 |
street_other |
Street other |
| 539 |
city_other |
City other |
| 540 |
postal_code_other |
Postal code other |
| 541 |
country_other |
Country other |
| 542 |
telephone_business1 |
Telephone business 1 |
| 543 |
telephone_business2 |
Telephone business 2 |
| 544 |
fax_business |
FAX business |
| 545 |
telephone_callback |
Telephone callback |
| 546 |
telephone_car |
Telephone car |
| 547 |
telephone_company |
Telephone company |
| 548 |
telephone_home1 |
Telephone home 1 |
| 549 |
telephone_home2 |
Telephone home 2 |
| 550 |
fax_home |
FAX home |
| 551 |
cellular_telephone1 |
Cellular telephone 1 |
| 552 |
cellular_telephone2 |
Cellular telephone 2 |
| 553 |
telephone_other |
Telephone other |
| 554 |
fax_other |
FAX other |
| 555 |
email1 |
Email 1 |
| 556 |
email2 |
Email 2 |
| 557 |
email3 |
Email 3 |
| 558 |
url |
URL |
| 559 |
telephone_isdn |
Telephone ISDN |
| 560 |
telephone_pager |
Telephone pager |
| 561 |
telephone_primary |
Telephone primary |
| 562 |
telephone_radio |
Telephone radio |
| 563 |
telephone_telex |
Telephone telex |
| 564 |
telephone_ttytdd |
Telephone TTY/TDD |
| 565 |
instant_messenger1 |
Instantmessenger 1 |
| 566 |
instant_messenger2 |
Instantmessenger 2 |
| 567 |
telephone_ip |
Telephone IP |
| 568 |
telephone_assistant |
Telephone assistant |
| 569 |
company |
Company |
| 570 |
image1 |
|
| 571 |
userfield01 |
Dynamic Field 1 |
| 572 |
userfield02 |
Dynamic Field 2 |
| 573 |
userfield03 |
Dynamic Field 3 |
| 574 |
userfield04 |
Dynamic Field 4 |
| 575 |
userfield05 |
Dynamic Field 5 |
| 576 |
userfield06 |
Dynamic Field 6 |
| 577 |
userfield07 |
Dynamic Field 7 |
| 578 |
userfield08 |
Dynamic Field 8 |
| 579 |
userfield09 |
Dynamic Field 9 |
| 580 |
userfield10 |
Dynamic Field 10 |
| 581 |
userfield11 |
Dynamic Field 11 |
| 582 |
userfield12 |
Dynamic Field 12 |
| 583 |
userfield13 |
Dynamic Field 13 |
| 584 |
userfield14 |
Dynamic Field 14 |
| 585 |
userfield15 |
Dynamic Field 15 |
| 586 |
userfield16 |
Dynamic Field 16 |
| 587 |
userfield17 |
Dynamic Field 17 |
| 588 |
userfield18 |
Dynamic Field 18 |
| 589 |
userfield19 |
Dynamic Field 19 |
| 590 |
userfield20 |
Dynamic Field 20 |
| 592 |
distribution_list |
|
| 594 |
number_of_distribution_list |
Number of distributionlists |
| 596 |
number_of_images |
|
| 597 |
image_last_modified |
|
| 598 |
state_other |
State other |
| 599 |
file_as |
|
| 601 |
image1_content_type |
|
| 602 |
mark_as_distributionlist |
|
| 605 |
default_address |
Default address |
| 606 |
image1_url |
|
| 608 |
useCount |
|
| 610 |
yomiFirstName |
|
| 611 |
yomiLastName |
|
| 612 |
yomiCompany |
|
| 613 |
addressHome |
|
| 614 |
addressBusiness |
|
| 615 |
addressOther |
|
Detailed appointment data
| ID |
Name |
| 206 |
recurrence_id |
| 207 |
recurrence_position |
| 208 |
recurrence_date_position |
| 210 |
change_exceptions |
| 211 |
delete_exceptions |
| 400 |
location |
| 402 |
shown_as |
| 408 |
timezone |
| 410 |
recurrence_start |
Detailed mail data
| ID |
Name |
| 102 |
color_label |
| 600 |
id |
| 601 |
folder_id |
| 602 |
attachment |
| 603 |
from |
| 604 |
to |
| 605 |
cc |
| 606 |
bcc |
| 607 |
subject |
| 608 |
size |
| 609 |
sent_date |
| 610 |
received_date |
| 611 |
flags |
| 612 |
level |
| 613 |
disp_notification_to |
| 614 |
priority |
| 615 |
msg_ref |
| 651 |
flag_seen |
| 652 |
account_name |
| 653 |
account_id |
| 654 |
original_id |
| 655 |
original_folder_id |
Detailed infoitem data
| ID |
Name |
| 108 |
object_permissions |
| 109 |
shareable |
| 700 |
title |
| 701 |
url |
| 702 |
filename |
| 703 |
file_mimetype |
| 704 |
file_size |
| 705 |
version |
| 706 |
description |
| 707 |
locked_until |
| 708 |
file_md5sum |
| 709 |
version_comment |
| 710 |
current_version |
| 711 |
number_of_versions |
| 7010 |
com.openexchange.share.extendedObjectPermissions |
| 7020 |
com.openexchange.realtime.resourceID |
| 7030 |
com.openexchange.file.storage.mail.mailMetadata |
Attachment data
| ID |
Name |
| 800 |
folder |
| 801 |
attached |
| 802 |
module |
| 803 |
filename |
| 804 |
file_size |
| 805 |
file_mimetype |
| 806 |
rft_flag |
Mail account data
| ID |
Name |
| 1001 |
id |
| 1002 |
login |
| 1003 |
password |
| 1004 |
mail_url |
| 1005 |
transport_url |
| 1006 |
name |
| 1007 |
primary_address |
| 1008 |
spam_handler |
| 1009 |
trash |
| 1010 |
sent |
| 1011 |
drafts |
| 1012 |
spam |
| 1013 |
confirmed_spam |
| 1014 |
confirmed_ham |
| 1015 |
mail_server |
| 1016 |
mail_port |
| 1017 |
mail_protocol |
| 1018 |
mail_secure |
| 1019 |
transport_server |
| 1020 |
transport_port |
| 1021 |
transport_protocol |
| 1022 |
transport_secure |
| 1023 |
transport_login |
| 1024 |
transport_password |
| 1025 |
unified_inbox_enabled |
| 1026 |
trash_fullname |
| 1027 |
sent_fullname |
| 1028 |
drafts_fullname |
| 1029 |
spam_fullname |
| 1030 |
confirmed_spam_fullname |
| 1031 |
confirmed_ham_fullname |
| 1032 |
pop3_refresh_rate |
| 1033 |
pop3_expunge_on_quit |
| 1034 |
pop3_delete_write_through |
| 1035 |
pop3_storage |
| 1036 |
pop3_path |
| 1037 |
personal |
| 1038 |
reply_to |
| 1039 |
addresses |
| 1040 |
meta |
| 1041 |
archive |
| 1042 |
archive_fullname |
| 1043 |
transport_auth |
| 1044 |
mail_starttls |
| 1045 |
transport_starttls |
Detailed user data
| ID |
Name |
| 610 |
aliases |
| 611 |
timezone |
| 612 |
locale |
| 613 |
groups |
| 614 |
contact_id |
| 615 |
login_info |
| 616 |
guest_created_by |
Messaging fields
| Name |
| id |
| folder |
| from |
| to |
| cc |
| bcc |
| headers |
| subject |
| body |
| contentType |
| size |
| sentDate |
| receivedDate |
| flags |
| threadLevel |
| dispositionNotificationTo |
| priority |
| colorLabel |
| url |
| picture |
