Microsoft: Users user schemas (part 15)

12 Microsoft schemas with complete fields and constraints.

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook video @odata type, audio Bits Per Sample, audio Channels, audio Format, audio Samples Per Second, bitrate, duration, four CC, frame Rate, height, width

Field	Type	Presence	Description and constraints
`$`	object	Root
`@odata.type`	string	Optional
`audioBitsPerSample`	JSON	Optional
`audioBitsPerSample (anyOf 1)`	JSON	Alternative
`audioBitsPerSample (anyOf 1) (anyOf 1)`	number	Alternative	Number of audio bits per sample. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`audioBitsPerSample (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`audioBitsPerSample (anyOf 2)`	null	Alternative
`audioChannels`	JSON	Optional
`audioChannels (anyOf 1)`	JSON	Alternative
`audioChannels (anyOf 1) (anyOf 1)`	number	Alternative	Number of audio channels. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`audioChannels (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`audioChannels (anyOf 2)`	null	Alternative
`audioFormat`	JSON	Optional
`audioFormat (anyOf 1)`	string	Alternative	Name of the audio format (AAC, MP3, etc.).
`audioFormat (anyOf 2)`	null	Alternative
`audioSamplesPerSecond`	JSON	Optional
`audioSamplesPerSecond (anyOf 1)`	JSON	Alternative
`audioSamplesPerSecond (anyOf 1) (anyOf 1)`	number	Alternative	Number of audio samples per second. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`audioSamplesPerSecond (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`audioSamplesPerSecond (anyOf 2)`	null	Alternative
`bitrate`	JSON	Optional
`bitrate (anyOf 1)`	JSON	Alternative
`bitrate (anyOf 1) (anyOf 1)`	number	Alternative	Bit rate of the video in bits per second. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`bitrate (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`bitrate (anyOf 2)`	null	Alternative
`duration`	JSON	Optional
`duration (anyOf 1)`	JSON	Alternative
`duration (anyOf 1) (anyOf 1)`	number	Alternative	Duration of the file in milliseconds. Format: int64
`duration (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`duration (anyOf 2)`	null	Alternative
`fourCC`	JSON	Optional
`fourCC (anyOf 1)`	string	Alternative	'Four character code' name of the video format.
`fourCC (anyOf 2)`	null	Alternative
`frameRate`	JSON	Optional	Frame rate of the video.
`frameRate (anyOf 1)`	JSON	Alternative
`frameRate (anyOf 1) (anyOf 1)`	JSON	Alternative
`frameRate (anyOf 1) (anyOf 1) (anyOf 1)`	number	Alternative	Format: double
`frameRate (anyOf 1) (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`frameRate (anyOf 1) (anyOf 2)`	null	Alternative
`frameRate (anyOf 2)`	JSON	Alternative
`frameRate (anyOf 2) (anyOf 1)`	string	Alternative
`frameRate (anyOf 2) (anyOf 2)`	null	Alternative
`frameRate (anyOf 3)`	Model	Alternative	Expand Get event — response body — @odata type, allow New Time Proposals, attachments, attendees, body, body Preview, calendar, cancelled Occurrences, end, exception Occurrences, extensions, has Attachments, hide Attendees, i Cal U Id, importance, instances, is All Day, is Cancelled, is Draft, is Online Meeting, is Organizer, is Reminder On, location, locations, multi Value Extended Properties, online Meeting, online Meeting Provider, online Meeting Url, organizer, original End Time Zone, original Start, original Start Time Zone, recurrence, reminder Minutes Before Start, response Requested, response Status, sensitivity, series Master Id, show As, single Value Extended Properties, start, subject, transaction Id, type, web Link locations item coordinates @odata type, accuracy, altitude, altitude Accuracy, latitude, longitude accuracy value
`height`	JSON	Optional
`height (anyOf 1)`	JSON	Alternative
`height (anyOf 1) (anyOf 1)`	number	Alternative	Height of the video, in pixels. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`height (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`height (anyOf 2)`	null	Alternative
`width`	JSON	Optional
`width (anyOf 1)`	JSON	Alternative
`width (anyOf 1) (anyOf 1)`	number	Alternative	Width of the video, in pixels. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`width (anyOf 1) (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`width (anyOf 2)`	null	Alternative

Referenced models: Get event — response body — @odata type, allow New Time Proposals, attachments, attendees, body, body Preview, calendar, cancelled Occurrences, end, exception Occurrences, extensions, has Attachments, hide Attendees, i Cal U Id, importance, instances, is All Day, is Cancelled, is Draft, is Online Meeting, is Organizer, is Reminder On, location, locations, multi Value Extended Properties, online Meeting, online Meeting Provider, online Meeting Url, organizer, original End Time Zone, original Start, original Start Time Zone, recurrence, reminder Minutes Before Start, response Requested, response Status, sensitivity, series Master Id, show As, single Value Extended Properties, start, subject, transaction Id, type, web Link locations item coordinates @odata type, accuracy, altitude, altitude Accuracy, latitude, longitude accuracy value

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).application`	JSON	Optional
`$ (allOf 2).application (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets application @odata type, calculation Mode, id
`$ (allOf 2).application (anyOf 2)`	JSON	Alternative
`$ (allOf 2).application (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).application (anyOf 2) (anyOf 2)`	null	Alternative
`$ (allOf 2).comments`	array	Optional	Represents a collection of comments in a workbook.
`$ (allOf 2).comments[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets comments item
`$ (allOf 2).functions`	JSON	Optional
`$ (allOf 2).functions (anyOf 1)`	Model	Alternative	Expand Create User — request body — body @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type adhoc Calls item
`$ (allOf 2).functions (anyOf 2)`	JSON	Alternative
`$ (allOf 2).functions (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).functions (anyOf 2) (anyOf 2)`	null	Alternative
`$ (allOf 2).names`	array	Optional	Represents a collection of workbooks scoped named items (named ranges and constants). Read-only.
`$ (allOf 2).names[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets names item
`$ (allOf 2).operations`	array	Optional	The status of workbook operations. Getting an operation collection is not supported, but you can get the status of a long-running operation if the Location header is returned in the response. Read-only.
`$ (allOf 2).operations[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets operations item
`$ (allOf 2).tables`	array	Optional	Represents a collection of tables associated with the workbook. Read-only.
`$ (allOf 2).tables[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item
`$ (allOf 2).worksheets`	array	Optional	Represents a collection of worksheets associated with the workbook. Read-only.
`$ (allOf 2).worksheets[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets worksheets item

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets application @odata type, calculation Mode, id

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).calculationMode`	string	Optional	Returns the calculation mode used in the workbook. The possible values are: Automatic, AutomaticExceptTables, Manual.

Referenced models: Get rule — response body — @odata type, id

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets comments item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).content`	JSON	Optional
`$ (allOf 2).content (anyOf 1)`	string	Alternative	The content of the comment.
`$ (allOf 2).content (anyOf 2)`	null	Alternative
`$ (allOf 2).contentType`	string	Optional	The content type of the comment.
`$ (allOf 2).replies`	array	Optional	The list of replies to the comment. Read-only. Nullable.
`$ (allOf 2).replies[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets comments item @odata type, content, content Type, replies replies item

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets comments item @odata type, content, content Type, replies replies item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).content`	JSON	Optional
`$ (allOf 2).content (anyOf 1)`	string	Alternative	The content of the reply.
`$ (allOf 2).content (anyOf 2)`	null	Alternative
`$ (allOf 2).contentType`	string	Optional	The content type for the reply.

Referenced models: Get rule — response body — @odata type, id

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets names item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).comment`	JSON	Optional
`$ (allOf 2).comment (anyOf 1)`	string	Alternative	The comment associated with this name.
`$ (allOf 2).comment (anyOf 2)`	null	Alternative
`$ (allOf 2).name`	JSON	Optional
`$ (allOf 2).name (anyOf 1)`	string	Alternative	The name of the object. Read-only.
`$ (allOf 2).name (anyOf 2)`	null	Alternative
`$ (allOf 2).scope`	string	Optional	Indicates whether the name is scoped to the workbook or to a specific worksheet. Read-only.
`$ (allOf 2).type`	JSON	Optional
`$ (allOf 2).type (anyOf 1)`	string	Alternative	The type of reference is associated with the name. The possible values are: String, Integer, Double, Boolean, Range. Read-only.
`$ (allOf 2).type (anyOf 2)`	null	Alternative
`$ (allOf 2).value`	JSON	Optional	The formula that the name is defined to refer to. For example, =Sheet14!$B$2:$H$12 and =4.75. Read-only.
`$ (allOf 2).visible`	boolean	Optional	Indicates whether the object is visible.
`$ (allOf 2).worksheet`	JSON	Optional	Returns the worksheet to which the named item is scoped. Available only if the item is scoped to the worksheet. Read-only.
`$ (allOf 2).worksheet (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets worksheets item
`$ (allOf 2).worksheet (anyOf 2)`	JSON	Alternative
`$ (allOf 2).worksheet (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).worksheet (anyOf 2) (anyOf 2)`	null	Alternative

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets operations item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).error`	JSON	Optional	The error returned by the operation.
`$ (allOf 2).error (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata.type, aboutMe, accountEnabled, activities, adhocCalls, ageGroup, agreementAcceptances, appRoleAssignments, assignedLicenses, assignedPlans, authentication, authorizationInfo, birthday, businessPhones, calendar, calendarGroups, calendarView, calendars, chats, city, cloudClipboard, cloudPCs, companyName, consentProvidedForMinor, contactFolders, contacts, country, createdDateTime, createdObjects, creationType, customSecurityAttributes, dataSecurityAndGovernance, department, deviceEnrollmentLimit, deviceManagementTroubleshootingEvents, directReports, displayName, drive, drives, employeeExperience, employeeHireDate, employeeId, employeeLeaveDateTime, employeeOrgData, employeeType, events, extensions, externalUserState, externalUserStateChangeDateTime, faxNumber, followedSites, givenName, hireDate, identities, identityParentId, imAddresses, inferenceClassification, insights, interests, isManagementRestricted, isResourceAccount, jobTitle, joinedTeams, lastPasswordChangeDateTime, legalAgeGroupClassification, licenseAssignmentStates, licenseDetails, mail, mailFolders, mailNickname, mailboxSettings, managedAppRegistrations, managedDevices, manager, memberOf, messages, mobilePhone, mySite, notes, oauth2PermissionGrants, officeLocation, onPremisesDistinguishedName, onPremisesDomainName, onPremisesExtensionAttributes, onPremisesImmutableId, onPremisesLastSyncDateTime, onPremisesProvisioningErrors, onPremisesSamAccountName, onPremisesSecurityIdentifier, onPremisesSyncBehavior, onPremisesSyncEnabled, onPremisesUserPrincipalName, onenote, onlineMeetings, otherMails, outlook, ownedDevices, ownedObjects, passwordPolicies, passwordProfile, pastProjects, people, permissionGrants, photo, photos, planner, postalCode, preferredDataLocation, preferredLanguage, preferredName, presence, print, provisionedPlans, proxyAddresses, registeredDevices, responsibilities, schools, scopedRoleMemberOf, securityIdentifier, serviceProvisioningErrors, settings, showInAddressList, signInActivity, signInSessionsValidFromDateTime, skills, solutions, sponsorOf, sponsors, state, streetAddress, surname, teamwork, todo, transitiveMemberOf, usageLocation, userPrincipalName, userType / drives / item / @odata.type, bundles, driveType, following, items, list, owner, quota, root, sharePointIds, special, system / items / item / @odata.type, analytics, audio, bundle, cTag, children, content, deleted, file, fileSystemInfo, folder, image, listItem, location, malware, package, pendingOperations, permissions, photo, publication, remoteItem, retentionLabel, root, searchResult, shared, sharepointIds, size, specialFolder, subscriptions, thumbnails, versions, video, webDavUrl, workbook / workbook / @odata.type, application, comments, functions, id, names, operations, tables, worksheets / @odata.type, application, comments, functions, names, operations, tables, worksheets / operations / item / status: not Started, running, succeeded, failed error @odata type, code, inner Error, message
`$ (allOf 2).error (anyOf 2)`	JSON	Alternative
`$ (allOf 2).error (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).error (anyOf 2) (anyOf 2)`	null	Alternative
`$ (allOf 2).resourceLocation`	JSON	Optional
`$ (allOf 2).resourceLocation (anyOf 1)`	string	Alternative	The resource URI for the result.
`$ (allOf 2).resourceLocation (anyOf 2)`	null	Alternative
`$ (allOf 2).status`	string	Optional	Known values: notStarted, running, succeeded, failed

Referenced models: Get rule — response body — @odata type, id, Create User — response body — @odata.type, aboutMe, accountEnabled, activities, adhocCalls, ageGroup, agreementAcceptances, appRoleAssignments, assignedLicenses, assignedPlans, authentication, authorizationInfo, birthday, businessPhones, calendar, calendarGroups, calendarView, calendars, chats, city, cloudClipboard, cloudPCs, companyName, consentProvidedForMinor, contactFolders, contacts, country, createdDateTime, createdObjects, creationType, customSecurityAttributes, dataSecurityAndGovernance, department, deviceEnrollmentLimit, deviceManagementTroubleshootingEvents, directReports, displayName, drive, drives, employeeExperience, employeeHireDate, employeeId, employeeLeaveDateTime, employeeOrgData, employeeType, events, extensions, externalUserState, externalUserStateChangeDateTime, faxNumber, followedSites, givenName, hireDate, identities, identityParentId, imAddresses, inferenceClassification, insights, interests, isManagementRestricted, isResourceAccount, jobTitle, joinedTeams, lastPasswordChangeDateTime, legalAgeGroupClassification, licenseAssignmentStates, licenseDetails, mail, mailFolders, mailNickname, mailboxSettings, managedAppRegistrations, managedDevices, manager, memberOf, messages, mobilePhone, mySite, notes, oauth2PermissionGrants, officeLocation, onPremisesDistinguishedName, onPremisesDomainName, onPremisesExtensionAttributes, onPremisesImmutableId, onPremisesLastSyncDateTime, onPremisesProvisioningErrors, onPremisesSamAccountName, onPremisesSecurityIdentifier, onPremisesSyncBehavior, onPremisesSyncEnabled, onPremisesUserPrincipalName, onenote, onlineMeetings, otherMails, outlook, ownedDevices, ownedObjects, passwordPolicies, passwordProfile, pastProjects, people, permissionGrants, photo, photos, planner, postalCode, preferredDataLocation, preferredLanguage, preferredName, presence, print, provisionedPlans, proxyAddresses, registeredDevices, responsibilities, schools, scopedRoleMemberOf, securityIdentifier, serviceProvisioningErrors, settings, showInAddressList, signInActivity, signInSessionsValidFromDateTime, skills, solutions, sponsorOf, sponsors, state, streetAddress, surname, teamwork, todo, transitiveMemberOf, usageLocation, userPrincipalName, userType / drives / item / @odata.type, bundles, driveType, following, items, list, owner, quota, root, sharePointIds, special, system / items / item / @odata.type, analytics, audio, bundle, cTag, children, content, deleted, file, fileSystemInfo, folder, image, listItem, location, malware, package, pendingOperations, permissions, photo, publication, remoteItem, retentionLabel, root, searchResult, shared, sharepointIds, size, specialFolder, subscriptions, thumbnails, versions, video, webDavUrl, workbook / workbook / @odata.type, application, comments, functions, id, names, operations, tables, worksheets / @odata.type, application, comments, functions, names, operations, tables, worksheets / operations / item / status: not Started, running, succeeded, failed error @odata type, code, inner Error, message

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).columns`	array	Optional	The list of all the columns in the table. Read-only.
`$ (allOf 2).columns[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet columns item
`$ (allOf 2).highlightFirstColumn`	boolean	Optional	Indicates whether the first column contains special formatting.
`$ (allOf 2).highlightLastColumn`	boolean	Optional	Indicates whether the last column contains special formatting.
`$ (allOf 2).legacyId`	JSON	Optional
`$ (allOf 2).legacyId (anyOf 1)`	string	Alternative	A legacy identifier used in older Excel clients. The value of the identifier remains the same even when the table is renamed. This property should be interpreted as an opaque string value and shouldn't be parsed to any other type. Read-only.
`$ (allOf 2).legacyId (anyOf 2)`	null	Alternative
`$ (allOf 2).name`	JSON	Optional
`$ (allOf 2).name (anyOf 1)`	string	Alternative	The name of the table.
`$ (allOf 2).name (anyOf 2)`	null	Alternative
`$ (allOf 2).rows`	array	Optional	The list of all the rows in the table. Read-only.
`$ (allOf 2).rows[]`	Model	Each item	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet rows item
`$ (allOf 2).showBandedColumns`	boolean	Optional	Indicates whether the columns show banded formatting in which odd columns are highlighted differently from even ones to make reading the table easier.
`$ (allOf 2).showBandedRows`	boolean	Optional	Indicates whether the rows show banded formatting in which odd rows are highlighted differently from even ones to make reading the table easier.
`$ (allOf 2).showFilterButton`	boolean	Optional	Indicates whether the filter buttons are visible at the top of each column header. Setting this is only allowed if the table contains a header row.
`$ (allOf 2).showHeaders`	boolean	Optional	Indicates whether the header row is visible or not. This value can be set to show or remove the header row.
`$ (allOf 2).showTotals`	boolean	Optional	Indicates whether the total row is visible or not. This value can be set to show or remove the total row.
`$ (allOf 2).sort`	JSON	Optional	The sorting for the table. Read-only.
`$ (allOf 2).sort (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet sort @odata type, fields, id, match Case, method
`$ (allOf 2).sort (anyOf 2)`	JSON	Alternative
`$ (allOf 2).sort (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).sort (anyOf 2) (anyOf 2)`	null	Alternative
`$ (allOf 2).style`	JSON	Optional
`$ (allOf 2).style (anyOf 1)`	string	Alternative	A constant value that represents the Table style. The possible values are: TableStyleLight1 through TableStyleLight21, TableStyleMedium1 through TableStyleMedium28, TableStyleStyleDark1 through TableStyleStyleDark11. A custom user-defined style present in the workbook can also be specified.
`$ (allOf 2).style (anyOf 2)`	null	Alternative
`$ (allOf 2).worksheet`	JSON	Optional	The worksheet containing the current table. Read-only.
`$ (allOf 2).worksheet (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets worksheets item
`$ (allOf 2).worksheet (anyOf 2)`	JSON	Alternative
`$ (allOf 2).worksheet (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).worksheet (anyOf 2) (anyOf 2)`	null	Alternative

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet columns item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).filter`	JSON	Optional	The filter applied to the column. Read-only.
`$ (allOf 2).filter (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet columns item @odata type, filter, index, name, values filter @odata type, criteria, id
`$ (allOf 2).filter (anyOf 2)`	JSON	Alternative
`$ (allOf 2).filter (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).filter (anyOf 2) (anyOf 2)`	null	Alternative
`$ (allOf 2).index`	JSON	Optional
`$ (allOf 2).index (anyOf 1)`	number	Alternative	The index of the column within the columns collection of the table. Zero-indexed. Read-only. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`$ (allOf 2).index (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`$ (allOf 2).name`	JSON	Optional
`$ (allOf 2).name (anyOf 1)`	string	Alternative	The name of the table column.
`$ (allOf 2).name (anyOf 2)`	null	Alternative
`$ (allOf 2).values`	JSON	Optional	TRepresents the raw values of the specified range. The data returned could be of type string, number, or a Boolean. Cell that contain an error will return the error string.

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet columns item @odata type, filter, index, name, values filter @odata type, criteria, id

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).criteria`	JSON	Optional	The currently applied filter on the given column. Read-only.
`$ (allOf 2).criteria (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet columns item @odata type, filter, index, name, values filter @odata type, criteria, id @odata type, criteria criteria @odata type, color, criterion1, criterion2, dynamic Criteria, filter On, icon, operator, values
`$ (allOf 2).criteria (anyOf 2)`	JSON	Alternative
`$ (allOf 2).criteria (anyOf 2) (anyOf 1)`	object	Alternative
`$ (allOf 2).criteria (anyOf 2) (anyOf 2)`	null	Alternative

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet columns item @odata type, filter, index, name, values filter @odata type, criteria, id @odata type, criteria criteria @odata type, color, criterion1, criterion2, dynamic Criteria, filter On, icon, operator, values

Field	Type	Presence	Description and constraints
`$`	object	Root
`@odata.type`	string	Optional
`color`	JSON	Optional
`color (anyOf 1)`	string	Alternative	The color applied to the cell.
`color (anyOf 2)`	null	Alternative
`criterion1`	JSON	Optional
`criterion1 (anyOf 1)`	string	Alternative	A custom criterion.
`criterion1 (anyOf 2)`	null	Alternative
`criterion2`	JSON	Optional
`criterion2 (anyOf 1)`	string	Alternative	A custom criterion.
`criterion2 (anyOf 2)`	null	Alternative
`dynamicCriteria`	string	Optional	A dynamic formula specified in a custom filter.
`filterOn`	string	Optional	Indicates whether a filter is applied to a column.
`icon`	JSON	Optional	An icon applied to a cell via conditional formatting.
`icon (anyOf 1)`	Model	Alternative	Expand Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet sort @odata type, fields, id, match Case, method @odata type, fields, match Case, method fields item icon @odata type, index, set
`icon (anyOf 2)`	JSON	Alternative
`icon (anyOf 2) (anyOf 1)`	object	Alternative
`icon (anyOf 2) (anyOf 2)`	null	Alternative
`operator`	string	Optional	An operator in a cell; for example, =, >, <, <=, or <>.
`values`	JSON	Optional	The values that appear in the cell.

Referenced models: Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet sort @odata type, fields, id, match Case, method @odata type, fields, match Case, method fields item icon @odata type, index, set

Create User — response body — @odata type, about Me, account Enabled, activities, adhoc Calls, age Group, agreement Acceptances, app Role Assignments, assigned Licenses, assigned Plans, authentication, authorization Info, birthday, business Phones, calendar, calendar Groups, calendar View, calendars, chats, city, cloud Clipboard, cloud P Cs, company Name, consent Provided For Minor, contact Folders, contacts, country, created Date Time, created Objects, creation Type, custom Security Attributes, data Security And Governance, department, device Enrollment Limit, device Management Troubleshooting Events, direct Reports, display Name, drive, drives, employee Experience, employee Hire Date, employee Id, employee Leave Date Time, employee Org Data, employee Type, events, extensions, external User State, external User State Change Date Time, fax Number, followed Sites, given Name, hire Date, identities, identity Parent Id, im Addresses, inference Classification, insights, interests, is Management Restricted, is Resource Account, job Title, joined Teams, last Password Change Date Time, legal Age Group Classification, license Assignment States, license Details, mail, mail Folders, mail Nickname, mailbox Settings, managed App Registrations, managed Devices, manager, member Of, messages, mobile Phone, my Site, notes, oauth2 Permission Grants, office Location, on Premises Distinguished Name, on Premises Domain Name, on Premises Extension Attributes, on Premises Immutable Id, on Premises Last Sync Date Time, on Premises Provisioning Errors, on Premises Sam Account Name, on Premises Security Identifier, on Premises Sync Behavior, on Premises Sync Enabled, on Premises User Principal Name, onenote, online Meetings, other Mails, outlook, owned Devices, owned Objects, password Policies, password Profile, past Projects, people, permission Grants, photo, photos, planner, postal Code, preferred Data Location, preferred Language, preferred Name, presence, print, provisioned Plans, proxy Addresses, registered Devices, responsibilities, schools, scoped Role Member Of, security Identifier, service Provisioning Errors, settings, show In Address List, sign In Activity, sign In Sessions Valid From Date Time, skills, solutions, sponsor Of, sponsors, state, street Address, surname, teamwork, todo, transitive Member Of, usage Location, user Principal Name, user Type drives item @odata type, bundles, drive Type, following, items, list, owner, quota, root, share Point Ids, special, system items item @odata type, analytics, audio, bundle, c Tag, children, content, deleted, file, file System Info, folder, image, list Item, location, malware, package, pending Operations, permissions, photo, publication, remote Item, retention Label, root, search Result, shared, sharepoint Ids, size, special Folder, subscriptions, thumbnails, versions, video, web Dav Url, workbook workbook @odata type, application, comments, functions, id, names, operations, tables, worksheets @odata type, application, comments, functions, names, operations, tables, worksheets tables item @odata type, columns, highlight First Column, highlight Last Column, legacy Id, name, rows, show Banded Columns, show Banded Rows, show Filter Button, show Headers, show Totals, sort, style, worksheet rows item

Field	Type	Presence	Description and constraints
`$`	JSON	Root
`$ (allOf 1)`	Model	All variants apply	Expand Get rule — response body — @odata type, id
`$ (allOf 2)`	object	All variants apply
`$ (allOf 2).@odata.type`	string	Optional
`$ (allOf 2).index`	JSON	Optional
`$ (allOf 2).index (anyOf 1)`	number	Alternative	The index of the row within the rows collection of the table. Zero-based. Read-only. Format: int32 Maximum: 2147483647 Minimum: -2147483648
`$ (allOf 2).index (anyOf 2)`	string	Alternative	Pattern: ^-?[0-9]+(?:\.[0-9]+)?(?:[eE][+-]?[0-9]+)?$
`$ (allOf 2).values`	JSON	Optional	The raw values of the specified range. The data returned could be of type string, number, or a Boolean. Any cell that contain an error will return the error string.

Referenced models: Get rule — response body — @odata type, id

Report an issue with this page