{"openapi":"3.0.1","info":{"title":"Wrike DataHub API","description":"This is Wrike DataHub public API.\n\nThere are several distinct entities\n\nData folders (not to be confused with Wrike Folders) are meant for organizing databases and navigation\n\nDatabase store actual user data as records (database rows) and define (through metadata) the record structure.\nThe record structure is defined as a collection of Fields","version":"0.1.1"},"servers":[{"url":"https://www.wrike.com/app/wrike_v2_web"},{"url":"https://app-eu.wrike.com/app/wrike_v2_web"},{"url":"https://app-us2.wrike.com/app/wrike_v2_web"}],"security":[{"bearer-auth":[]}],"paths":{"/public/api/v1/databases":{"get":{"tags":["Databases"],"summary":"Get databases","description":"this resource is used to to get the list of databases. If no ids specified, all available databases will be returned","operationId":"findDatabases","parameters":[{"$ref":"#/components/parameters/Pagination"},{"$ref":"#/components/parameters/DatabasesGetRequest"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabasesResponse"}}}}},"deprecated":false},"post":{"tags":["Databases"],"summary":"Create a new database within a given folder","operationId":"databasePost","requestBody":{"description":"Information on a new database","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabaseCreateRequest"}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabaseResponse"}}}}},"deprecated":false}},"/public/api/v1/databases/{databaseId}":{"get":{"tags":["Databases"],"summary":"Get one specific database","operationId":"findDatabase","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabaseResponse"}}}}},"deprecated":false},"delete":{"tags":["Databases"],"summary":"Delete an existing database","operationId":"deleteDatabase","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"204":{"description":"Empty response"}},"deprecated":false},"patch":{"tags":["Databases"],"summary":"Update a given database","operationId":"updateDatabase","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"description":"New information on an existing database","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabasesByIdUpdateRequest"}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabaseResponse"}}}}},"deprecated":false}},"/public/api/v1/folders/{folderId}/databases":{"get":{"tags":["Databases"],"summary":"Get the folder's databases","operationId":"findFolderDatabases","parameters":[{"name":"folderId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/Pagination"},{"$ref":"#/components/parameters/DatabasesGetRequest"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabasesResponse"}}}}},"deprecated":false}},"/public/api/v1/databases/{databaseId}/fields":{"get":{"tags":["Fields"],"summary":"Get the database columns (properties)","operationId":"findFields","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/Pagination"},{"$ref":"#/components/parameters/FieldsFilterGetRequest"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FieldsResponse"},"examples":{"Multiple fields":{"description":"Multiple fields","value":{"data":[{"type":"text","isMirror":false,"id":"FI413230","title":"text property"},{"type":"number","isMirror":false,"id":"FI413231","title":"number property"},{"type":"percent","isMirror":false,"id":"FI413232","title":"percentage property"},{"type":"checkbox","isMirror":false,"id":"FI413233","title":"checkbox property"},{"type":"duration","isMirror":false,"id":"FI413234","title":"duration property"},{"type":"currency","isMirror":false,"id":"FI413235","title":"currency property"},{"type":"date","isMirror":false,"id":"FI413236","title":"datetime property"},{"type":"singleSelect","id":"FI413237","title":"singleSelect property","allowedEnumValues":[{"id":"750b6b81-2f4b-42d1-bc5f-0506e37390ca","name":"name 1"},{"id":"6b618b7d-537d-4f5a-a345-0f7968fc1537","name":"name 2","color":"YellowGreen"}],"isMirror":false},{"type":"multiSelect","id":"FI413238","title":"multiSelect property","allowedEnumValues":[{"id":"93d4dfa2-1db9-4428-a698-7d21ad4a10d6","name":"name 3"}],"isMirror":false},{"type":"linkToDatabase","id":"FI413239","title":"Link to database single property","databaseId":"DB399565","allowMultipleEntries":false,"mirrorFields":[{"id":"FI413240","title":"Mirror field for Mirror Text property","fieldId":"FI413210"}],"isMirror":false},{"type":"text","isMirror":true,"id":"FI413240","title":"Mirror field for Mirror Text property"},{"type":"linkToDatabase","id":"FI413260","title":"Link to database multiple property","databaseId":"DB399566","allowMultipleEntries":true,"isMirror":false}],"total":12}}}}}}},"deprecated":false},"post":{"tags":["Fields"],"summary":"Create a new database field (property)","operationId":"createField","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"description":" Information on a new database field.\n\n **The below table defines the currently supported field parameters:**\n\n | type           | allowedEnumValues | databaseId      | allowMultipleEntries | mirrorFields                 | formula         | format          |\n | -------------- | ------------------|-----------------|----------------------|------------------------------|-----------------|-----------------|\n | text           | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | number         | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | percent        | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | checkbox       | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | date           | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | duration       | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | currency       | are ignored       | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | singleSelect   | must be present   | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | multiSelect    | must be present   | are ignored     | are ignored          | are ignored                  | are ignored     | are ignored     |\n | linkToDatabase | are ignored       | must be present | false/true           | can be present/must be empty | are ignored     | are ignored     |\n | formula        | are ignored       | are ignored     | are ignored          | are ignored                  | must be present | must be present |\n\n","content":{"application/json":{"schema":{"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldCreateRequest","multiSelect":"#/components/schemas/MultiSelectFieldCreateRequest","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldCreateRequest","formula":"#/components/schemas/FormulaFieldCreateRequest"}},"oneOf":[{"$ref":"#/components/schemas/FieldCreateRequest"},{"$ref":"#/components/schemas/SingleSelectFieldCreateRequest"},{"$ref":"#/components/schemas/MultiSelectFieldCreateRequest"},{"$ref":"#/components/schemas/LinkToDatabaseFieldCreateRequest"},{"$ref":"#/components/schemas/FormulaFieldCreateRequest"}]},"examples":{"Single select field":{"description":"Single select field","value":{"requestId":"77b8cb89-b7f4-4b80-b464-296e7a299fa0","title":"Select column","type":"singleSelect","readerIds":["KUAAAAAE"],"allowedEnumValues":[{"name":"Green option","color":"Green"},{"id":"a987eece-cf41-495d-810c-f6eda9b4716e","name":"Option without colour"}]}},"Link to database field with mirror fields":{"description":"Link to database field with mirror fields","value":{"requestId":"46d905b2-699e-4951-a9e2-3001b60cbdb3","title":"Link to database property","type":"linkToDatabase","databaseId":"DB399578","allowMultipleEntries":false,"readerIds":["KUAAAAAE"],"mirrorFields":[{"title":"Mirror for Currency property","fieldId":"FI413337"},{"title":"Mirror for Multiple select property","fieldId":"FI413339"}]}},"Formula field":{"description":"Formula field","value":{"requestId":"77b8cb89-b7f4-4b80-b464-296e7a299fa0","title":"Formula","type":"formula","formula":"(FI2145 - FI9585) / (FI1245 + 100)","format":"number"}}}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldResponse","multiSelect":"#/components/schemas/MultiSelectFieldResponse","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldResponse","formula":"#/components/schemas/FormulaFieldResponse"}},"oneOf":[{"$ref":"#/components/schemas/FieldResponse"},{"$ref":"#/components/schemas/SingleSelectFieldResponse"},{"$ref":"#/components/schemas/MultiSelectFieldResponse"},{"$ref":"#/components/schemas/LinkToDatabaseFieldResponse"},{"$ref":"#/components/schemas/FormulaFieldResponse"}]},"examples":{"Single select field":{"description":"Single select field","value":{"id":"FI217495","title":"Select column","type":"singleSelect","readerIds":["KUAAAAAE"],"allowedEnumValues":[{"id":"9a0184e3-9012-4e1e-a939-67c50e04ede6","name":"Green option","color":"Green"},{"id":"a987eece-cf41-495d-810c-f6eda9b4716e","name":"Option without colour"}]}},"Link to database field with mirror fields":{"description":"Link to database field with mirror fields","value":{"type":"linkToDatabase","id":"FI413340","title":"lookup property","databaseId":"DB399578","allowMultipleEntries":false,"readerIds":["KUAAAAAE"],"mirrorFields":[{"id":"FI413347","title":"Mirror for Currency property","fieldId":"FI413337"},{"id":"FI413348","title":"Mirror for Multiple select property","fieldId":"FI413339"}],"isMirror":false}}}}}}},"deprecated":false}},"/public/api/v1/databases/{databaseId}/fields/{fieldId}":{"get":{"tags":["Fields"],"summary":"Get a given database field (property)","operationId":"findField","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"name":"fieldId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldResponse","multiSelect":"#/components/schemas/MultiSelectFieldResponse","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldResponse"}},"oneOf":[{"$ref":"#/components/schemas/FieldResponse"},{"$ref":"#/components/schemas/SingleSelectFieldResponse"},{"$ref":"#/components/schemas/MultiSelectFieldResponse"},{"$ref":"#/components/schemas/LinkToDatabaseFieldResponse"}]},"examples":{"Date field":{"description":"Date field","value":{"type":"date","isMirror":false,"id":"FI413330","title":"datetime property"}}}}}}},"deprecated":false},"delete":{"tags":["Fields"],"summary":"Delete an existing database field (property)","operationId":"deleteField","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"name":"fieldId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"204":{"description":"Empty response"}},"deprecated":false},"patch":{"tags":["Fields"],"summary":"Update an existing database field (property)","operationId":"updateField","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"name":"fieldId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"description":"New information on an existing database field (property)","content":{"application/json":{"schema":{"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldUpdateRequest","multiSelect":"#/components/schemas/MultiSelectFieldUpdateRequest","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldUpdateRequest","formula":"#/components/schemas/FormulaFieldUpdateRequest"}},"oneOf":[{"$ref":"#/components/schemas/FieldUpdateRequest"},{"$ref":"#/components/schemas/SingleSelectFieldUpdateRequest"},{"$ref":"#/components/schemas/MultiSelectFieldUpdateRequest"},{"$ref":"#/components/schemas/LinkToDatabaseFieldUpdateRequest"},{"$ref":"#/components/schemas/FormulaFieldUpdateRequest"}]},"examples":{"Link to database field update":{"description":"Link to database field update","value":{"title":"new title","type":"linkToDatabase","readerIds":["KUAAAAAE"],"mirrorFieldsAdd":[{"title":"Added mirror field title","fieldId":"FI413485"}],"mirrorFieldsRemove":[{"wrikeFieldId":"FI413487"}]}},"Formula field update":{"description":"Formula field update","value":{"id":"FI413486","title":"New formula","type":"formula","formula":"(FI2145 - FI9585) / (FI1245 + 100)","format":"number"}}}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldResponse","multiSelect":"#/components/schemas/MultiSelectFieldResponse","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldResponse","formula":"#/components/schemas/FormulaFieldResponse"}},"oneOf":[{"$ref":"#/components/schemas/FieldResponse"},{"$ref":"#/components/schemas/SingleSelectFieldResponse"},{"$ref":"#/components/schemas/MultiSelectFieldResponse"},{"$ref":"#/components/schemas/LinkToDatabaseFieldResponse"},{"$ref":"#/components/schemas/FormulaFieldResponse"}]},"examples":{"Link to database field update":{"description":"Link to database field update","value":{"type":"linkToDatabase","id":"FI413486","title":"new title","databaseId":"DB399608","allowMultipleEntries":false,"readerIds":["KUAAAAAE"],"mirrorFields":[{"id":"FI413497","title":"Added  mirror field title","fieldId":"FI413485"}],"isMirror":false}},"Formula field":{"description":"Formula field","value":{"id":"FI413486","title":"New formula","type":"formula","formula":"(FI2145 - FI9585) / (FI1245 + 100)","format":"number"}}}}}}},"deprecated":false}},"/public/api/v1/folders":{"get":{"tags":["Folders"],"summary":"Get folders by ids","description":"this resource is used to to get the list of folder with known IDs. It also allows to load the whole folders subtree in one query","operationId":"findFolders","parameters":[{"$ref":"#/components/parameters/Pagination"},{"$ref":"#/components/parameters/FoldersGetRequestMandatory"},{"$ref":"#/components/parameters/withDescendants"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FoldersResponse"}}}}},"deprecated":false},"post":{"tags":["Folders"],"summary":"Create a new folder within a given folder","operationId":"foldersPost","requestBody":{"description":"Information on a new folder","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FolderCreateRequest"}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FolderResponse"}}}}},"deprecated":false}},"/public/api/v1/folders/{folderId}":{"get":{"tags":["Folders"],"summary":"Get one specific folder","operationId":"findFolder","parameters":[{"name":"folderId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FolderResponse"}}}}},"deprecated":false},"delete":{"tags":["Folders"],"summary":"Delete an existing folder","operationId":"deleteFolder","parameters":[{"name":"folderId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"204":{"description":"Empty response"}},"deprecated":false},"patch":{"tags":["Folders"],"summary":"Update a given folder","operationId":"updateFolder","parameters":[{"name":"folderId","in":"path","required":true,"schema":{"type":"string"}}],"requestBody":{"description":"New information on an existing folder","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FoldersByIdUpdateRequest"}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FolderResponse"}}}}},"deprecated":false}},"/public/api/v1/folders/{folderId}/folders":{"get":{"tags":["Folders"],"summary":"Get the folder's subfolders","operationId":"findSubFolders","parameters":[{"name":"folderId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/Pagination"},{"$ref":"#/components/parameters/FoldersGetRequest"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FoldersResponse"}}}}},"deprecated":false}},"/public/api/v1/databases/{databaseId}/records":{"get":{"tags":["Records"],"summary":"Get the database records along with requested fields values","operationId":"findRecords","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/Pagination"},{"$ref":"#/components/parameters/RecordsGetRequest"},{"$ref":"#/components/parameters/filter"},{"$ref":"#/components/parameters/searchQuery"},{"$ref":"#/components/parameters/FieldsGetRequest"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/RecordsResponse"}}}}},"deprecated":false},"post":{"tags":["Records"],"summary":"Create some new records","operationId":"createRecords","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/FieldsGetRequest"}],"requestBody":{"description":"List items to create","content":{"application/json":{"schema":{"$ref":"#/components/schemas/RecordsCreateRequest"}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabasesDatabaseIdRecordsCreateResponse"}}}}},"deprecated":false},"delete":{"tags":["Records"],"summary":"Delete several existing database records","operationId":"deleteRecords","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/RecordsDeleteRequest"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/RecordFailedResponseById"}}}}}},"deprecated":false},"patch":{"tags":["Records"],"summary":"Update some database records","operationId":"updateRecords","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/FieldsGetRequest"}],"requestBody":{"description":"An array of records along with field values to change in them","content":{"application/json":{"schema":{"type":"array","items":{"$ref":"#/components/schemas/RecordUpdateRequest"}}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/DatabasesDatabaseIdRecordsUpdateResponse"}}}}},"deprecated":false}},"/public/api/v1/databases/{databaseId}/records/{recordId}":{"get":{"tags":["Records"],"summary":"Get a given list item along with requested column values","operationId":"findRecord","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"name":"recordId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/FieldsGetRequest"},{"$ref":"#/components/parameters/includeDeleted"}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/RecordResponse"}}}}},"deprecated":false},"patch":{"tags":["Records"],"summary":"Update a given database record","operationId":"updateRecord","parameters":[{"name":"databaseId","in":"path","required":true,"schema":{"type":"string"}},{"name":"recordId","in":"path","required":true,"schema":{"type":"string"}},{"$ref":"#/components/parameters/FieldsGetRequest"}],"requestBody":{"description":"New information on an existing record","content":{"application/json":{"schema":{"$ref":"#/components/schemas/RecordCreateRequest"}}}},"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/RecordResponse"}}}}},"deprecated":false}},"/public/api/v1/spaces/{spaceId}/root/folder":{"get":{"tags":["Spaces"],"summary":"Get root folder for a space","operationId":"getRootFolder","parameters":[{"name":"spaceId","in":"path","required":true,"schema":{"type":"string"}}],"responses":{"200":{"description":"OK","content":{"application/json":{"schema":{"$ref":"#/components/schemas/FolderResponse"}}}}},"deprecated":false}}},"components":{"schemas":{"DatabaseCreateRequest":{"required":["parentFolderId","requestId","title"],"type":"object","properties":{"requestId":{"type":"string","description":"Should  be any unique value, e.g. UUID, current timestamp etc"},"title":{"type":"string"},"databaseRecordName":{"type":"string"},"parentFolderId":{"type":"string"}}},"DatabaseResponse":{"required":["id","title"],"type":"object","properties":{"id":{"type":"string"},"title":{"type":"string"},"parentFolderId":{"type":"string"},"databaseRecordName":{"type":"string"}}},"DatabasesResponse":{"required":["data","total"],"type":"object","properties":{"total":{"type":"integer","format":"int32"},"nextPageToken":{"type":"string"},"data":{"type":"array","items":{"$ref":"#/components/schemas/DatabaseResponse"}}}},"DatabasesByIdUpdateRequest":{"type":"object","properties":{"title":{"type":"string"},"parentFolderId":{"type":"string"}}},"FieldCreateRequest":{"required":["requestId","title","type"],"type":"object","properties":{"requestId":{"type":"string","description":"Should  be any unique value, e.g. UUID, current timestamp etc"},"title":{"type":"string"},"type":{"type":"string","enum":["id","text","number","percent","checkbox","date","duration","currency","singleSelect","multiSelect","linkToDatabase","formula"]},"readerIds":{"uniqueItems":true,"type":"array","items":{"type":"string"}}},"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldCreateRequest","multiSelect":"#/components/schemas/MultiSelectFieldCreateRequest","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldCreateRequest","formula":"#/components/schemas/FormulaFieldCreateRequest"}}},"FormulaFieldCreateRequest":{"required":["format","formula","requestId","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldCreateRequest"},{"type":"object","properties":{"formula":{"type":"string"},"format":{"type":"string","enum":["number","currency","percent","hours","days","date"]}}}]},"LinkToDatabaseFieldCreateRequest":{"required":["allowMultipleEntries","databaseId","requestId","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldCreateRequest"},{"type":"object","properties":{"databaseId":{"type":"string"},"allowMultipleEntries":{"type":"boolean"},"mirrorFields":{"type":"array","items":{"$ref":"#/components/schemas/MirrorFieldCreate"}}}}]},"MirrorFieldCreate":{"required":["fieldId","title"],"type":"object","properties":{"title":{"type":"string"},"fieldId":{"type":"string"}}},"MultiSelectFieldCreateRequest":{"required":["allowedEnumValues","requestId","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldCreateRequest"},{"type":"object","properties":{"allowedEnumValues":{"type":"array","items":{"$ref":"#/components/schemas/OptionWithColor"}}}}]},"OptionWithColor":{"required":["name"],"type":"object","properties":{"id":{"type":"string"},"name":{"type":"string"},"color":{"type":"string","enum":["Brown","Red","Purple","Indigo","DarkBlue","Blue","Turquoise","DarkCyan","Green","YellowGreen","Yellow","Orange","Gray","DarkRed"]}}},"SingleSelectFieldCreateRequest":{"required":["allowedEnumValues","requestId","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldCreateRequest"},{"type":"object","properties":{"allowedEnumValues":{"type":"array","items":{"$ref":"#/components/schemas/OptionWithColor"}}}}]},"FieldResponse":{"required":["id","isMirror","title","type"],"type":"object","properties":{"isMirror":{"type":"boolean"},"id":{"type":"string"},"title":{"type":"string"},"type":{"type":"string","enum":["id","text","number","percent","checkbox","date","duration","currency","singleSelect","multiSelect","linkToDatabase","formula"]},"readerIds":{"uniqueItems":true,"type":"array","items":{"type":"string"}}},"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldResponse","multiSelect":"#/components/schemas/MultiSelectFieldResponse","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldResponse","formula":"#/components/schemas/FormulaFieldResponse"}}},"FormulaFieldResponse":{"required":["format","formula","id","isMirror","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldResponse"},{"type":"object","properties":{"formula":{"type":"string"},"format":{"type":"string","enum":["number","currency","percent","hours","days","date"]}}}]},"LinkToDatabaseFieldResponse":{"required":["allowMultipleEntries","databaseId","id","isMirror","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldResponse"},{"type":"object","properties":{"databaseId":{"type":"string"},"allowMultipleEntries":{"type":"boolean"},"mirrorFields":{"type":"array","items":{"$ref":"#/components/schemas/MirrorField"}}}}]},"MirrorField":{"required":["fieldId","id","title"],"type":"object","properties":{"id":{"type":"string"},"title":{"type":"string"},"fieldId":{"type":"string"}}},"MultiSelectFieldResponse":{"required":["allowedEnumValues","id","isMirror","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldResponse"},{"type":"object","properties":{"allowedEnumValues":{"type":"array","items":{"$ref":"#/components/schemas/OptionWithColor"}}}}]},"SingleSelectFieldResponse":{"required":["allowedEnumValues","id","isMirror","title","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldResponse"},{"type":"object","properties":{"allowedEnumValues":{"type":"array","items":{"$ref":"#/components/schemas/OptionWithColor"}}}}]},"FieldUpdateRequest":{"required":["type"],"type":"object","properties":{"title":{"type":"string"},"type":{"type":"string","enum":["id","text","number","percent","checkbox","date","duration","currency","singleSelect","multiSelect","linkToDatabase","formula"]},"readerIds":{"uniqueItems":true,"type":"array","items":{"type":"string"}}},"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldUpdateRequest","multiSelect":"#/components/schemas/MultiSelectFieldUpdateRequest","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldUpdateRequest","formula":"#/components/schemas/FormulaFieldUpdateRequest"}}},"FormulaFieldUpdateRequest":{"required":["type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldUpdateRequest"},{"type":"object","properties":{"formula":{"type":"string"},"format":{"type":"string","enum":["number","currency","percent","hours","days","date"]}}}]},"LinkToDatabaseFieldUpdateRequest":{"required":["mirrorFieldsAdd","mirrorFieldsRemove","type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldUpdateRequest"},{"type":"object","properties":{"mirrorFieldsAdd":{"type":"array","items":{"$ref":"#/components/schemas/MirrorFieldCreate"}},"mirrorFieldsRemove":{"type":"array","items":{"$ref":"#/components/schemas/MirrorFieldRemove"}},"allowMultipleEntries":{"type":"boolean"},"databaseId":{"type":"string"}}}]},"MirrorFieldRemove":{"required":["wrikeFieldId"],"type":"object","properties":{"wrikeFieldId":{"type":"string"}}},"MultiSelectFieldUpdateRequest":{"required":["type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldUpdateRequest"},{"type":"object","properties":{"allowedEnumValues":{"type":"array","items":{"$ref":"#/components/schemas/OptionWithColor"}}}}]},"SingleSelectFieldUpdateRequest":{"required":["type"],"type":"object","allOf":[{"$ref":"#/components/schemas/FieldUpdateRequest"},{"type":"object","properties":{"allowedEnumValues":{"type":"array","items":{"$ref":"#/components/schemas/OptionWithColor"}}}}]},"FieldsResponse":{"required":["data","total"],"type":"object","properties":{"data":{"type":"array","items":{"discriminator":{"propertyName":"type","mapping":{"singleSelect":"#/components/schemas/SingleSelectFieldResponse","multiSelect":"#/components/schemas/MultiSelectFieldResponse","linkToDatabase":"#/components/schemas/LinkToDatabaseFieldResponse"}},"oneOf":[{"$ref":"#/components/schemas/FieldResponse"},{"$ref":"#/components/schemas/SingleSelectFieldResponse"},{"$ref":"#/components/schemas/MultiSelectFieldResponse"},{"$ref":"#/components/schemas/LinkToDatabaseFieldResponse"}]}},"total":{"type":"integer","format":"int32"},"nextPageToken":{"type":"string"}}},"FolderCreateRequest":{"required":["parentFolderId","requestId","title"],"type":"object","properties":{"requestId":{"type":"string","description":"Should  be any unique value, e.g. UUID, current timestamp etc"},"title":{"type":"string"},"parentFolderId":{"type":"string"}}},"FolderResponse":{"required":["id","title"],"type":"object","properties":{"id":{"type":"string"},"title":{"type":"string"},"parentFolderId":{"type":"string"}}},"FoldersResponse":{"required":["data","total"],"type":"object","properties":{"total":{"type":"integer","format":"int32"},"nextPageToken":{"type":"string"},"data":{"type":"array","items":{"$ref":"#/components/schemas/ModuleResponse"}}}},"ModuleResponse":{"required":["id","title"],"type":"object","properties":{"id":{"type":"string"},"title":{"type":"string"},"parentFolderId":{"type":"string"}}},"FoldersByIdUpdateRequest":{"type":"object","properties":{"title":{"type":"string"},"parentFolderId":{"type":"string"}}},"RecordsCreateRequest":{"required":["data","requestId"],"type":"object","properties":{"requestId":{"type":"string","description":"Should be any unique value, e.g. UUID, current timestamp etc"},"data":{"type":"array","items":{"$ref":"#/components/schemas/RecordCreateRequest"}}}},"RecordCreateRequest":{"required":["fieldValues","title"],"type":"object","properties":{"title":{"type":"string"},"fieldValues":{"type":"object","additionalProperties":{}}}},"DatabasesDatabaseIdRecordsCreateResponse":{"required":["data","failedItems"],"type":"object","properties":{"data":{"type":"array","items":{"$ref":"#/components/schemas/RecordResponse"}},"failedItems":{"type":"array","items":{"$ref":"#/components/schemas/RecordFailedResponseByIndex"}}}},"RecordFailedResponseByIndex":{"required":["failureReason","index"],"type":"object","properties":{"index":{"type":"integer","format":"int32"},"failureReason":{"type":"string"}}},"RecordResponse":{"required":["deleted","fieldValues","id","title"],"type":"object","properties":{"id":{"type":"string"},"title":{"type":"string"},"deleted":{"type":"boolean"},"fieldValues":{"type":"object","additionalProperties":{}}}},"ImmutableListRecordFailedResponseById":{"type":"array","items":{"$ref":"#/components/schemas/RecordFailedResponseById"}},"RecordFailedResponseById":{"required":["failureReason","id"],"type":"object","properties":{"id":{"type":"string"},"failureReason":{"type":"string"}}},"RecordUpdateRequest":{"required":["fieldValues","id"],"type":"object","properties":{"id":{"type":"string"},"title":{"type":"string"},"fieldValues":{"type":"object","additionalProperties":{}}}},"DatabasesDatabaseIdRecordsUpdateResponse":{"required":["data","failedItems"],"type":"object","properties":{"data":{"type":"array","items":{"$ref":"#/components/schemas/RecordResponse"}},"failedItems":{"type":"array","items":{"$ref":"#/components/schemas/RecordFailedResponseById"}}}},"RecordsResponse":{"required":["data","total"],"type":"object","properties":{"data":{"type":"array","items":{"$ref":"#/components/schemas/RecordResponse"}},"total":{"type":"integer","format":"int32"},"nextPageToken":{"type":"string"}}}},"parameters":{"Pagination":{"name":"Pagination","in":"query","description":"Pagination parameter","required":false,"schema":{"type":"object","properties":{"nextPageToken":{"type":"string"},"limit":{"maximum":1000,"minimum":1,"type":"integer","format":"int32","default":100}}}},"DatabasesGetRequest":{"name":"databaseIds","in":"query","description":"Databases filter parameter","required":false,"schema":{"type":"array","items":{"type":"string"}}},"FieldsFilterGetRequest":{"name":"fieldIds","in":"query","description":"Columns filter parameter","required":false,"schema":{"type":"array","items":{"type":"string"}}},"FoldersGetRequestMandatory":{"name":"folderIds","in":"query","description":"Folders filter parameter","required":true,"schema":{"type":"array","items":{"type":"string"}}},"withDescendants":{"name":"withDescendants","in":"query","required":false,"schema":{"type":"boolean"}},"FoldersGetRequest":{"name":"folderIds","in":"query","description":"Folders filter parameter","required":false,"schema":{"type":"array","items":{"type":"string"}}},"FieldsGetRequest":{"name":"fieldIds","in":"query","description":"Columns (properties) to be loaded in the result","required":false,"schema":{"type":"array","items":{"type":"string"}}},"RecordsDeleteRequest":{"name":"recordIds","in":"query","description":"Records to delete","required":true,"schema":{"type":"array","items":{"type":"string"}}},"includeDeleted":{"name":"includeDeleted","in":"query","description":"Include deleted records in the response","required":false,"schema":{"type":"boolean","default":true}},"RecordsGetRequest":{"name":"recordIds","in":"query","description":"Items filter parameter","required":false,"schema":{"type":"array","items":{"type":"string"}}},"filter":{"name":"filter","in":"query","description":"Filter parameter","required":false,"schema":{"type":"string","example":"{\"and\": [{\"or\": [{\"op\": \"equals\",\"fld\": \"FI123456\",\"val\": 224}]},{\"op\": \"isNotEmpty\",\"fld\": \"FI123654\"}]}"}},"searchQuery":{"name":"searchQuery","in":"query","description":"Search query by all fields. Special characters (\", <> etc. must be escaped). The value is ignored if items filter is provided","required":false,"schema":{"type":"string"}}},"securitySchemes":{"bearer-auth":{"type":"http","description":"See details at [Wrike Developers Portal](https://developers.wrike.com/oauth-20-authorization/)","scheme":"bearer","bearerFormat":"JWT"}}}}