openapi: 3.0.3 info: title: Factset Analytics Datastore About Database API description: Allow clients to fetch precalculated Analytics through predeterministic URLs. contact: name: FactSet Research Systems url: https://developer.factset.com/contact email: api@factset.com license: name: Apache License, Version 2.0 url: https://www.apache.org/licenses/LICENSE-2.0 version: 1.0.0 servers: - url: https://api.factset.com description: Production - url: https://api-sandbox.factset.com description: Sandbox security: - basicAuth: [] tags: - name: Database paths: /factset-prices/v1/database-rollover: get: summary: Factset Gets the Latest Relative Rollover Date for the Database. description: 'Gets zero relative date and last update time for FactSet databases. The dates represent the date that the rollover event happened; the date and time is in **eastern time zone**.
Depending on the ids requested and their respective regions, a requested startDate or endDate used in the various Prices API may reflect different previous close dates. This relative "zero" date, meaning - as of yesterday''s close - will vary across global regions. This API is designed to help production systems account for regional rollover dates to know when to trigger their processes for different regions to reflect the latest close. The response gives context for AMERICAS, ASIA PACIFIC, and EUROPE.
' tags: - Database operationId: getDatabaseRollover responses: '200': description: Database rollover data items. content: application/json: schema: $ref: '#/components/schemas/rolloverResponse' '400': $ref: '#/components/responses/400' '401': $ref: '#/components/responses/401' '403': $ref: '#/components/responses/403' '415': $ref: '#/components/responses/415' '500': $ref: '#/components/responses/500' x-microcks-operation: delay: 0 dispatcher: FALLBACK post: summary: Factset Gets the Latest Relative Rollover Date for the Database. description: 'Gets zero relative date and last update time for FactSet databases. The dates represent the date that the rollover event happened; the date and time is in **eastern time zone**.Depending on the ids requested and their respective regions, a requested startDate or endDate used in the various Prices API may reflect different previous close dates. This relative "zero" date, meaning - as of yesterday''s close - will vary across global regions. This API is designed to help production systems account for regional rollover dates to know when to trigger their processes for different regions to reflect the latest close. The response gives context for AMERICAS, ASIA PACIFIC, and EUROPE.
' tags: - Database operationId: getDatabaseRolloverForList responses: '200': description: Database rollover data items. content: application/json: schema: $ref: '#/components/schemas/rolloverResponse' '400': $ref: '#/components/responses/400' '401': $ref: '#/components/responses/401' '403': $ref: '#/components/responses/403' '415': $ref: '#/components/responses/415' '500': $ref: '#/components/responses/500' x-microcks-operation: delay: 0 dispatcher: FALLBACK /database/jobs/{id}/status: get: operationId: getStatus tags: - Database description: Returns the current status of a long running request. The full URL is normally provided for you in the Location header of a long running response. parameters: - $ref: '#/components/parameters/idPathParam' responses: '201': $ref: '#/components/responses/201LongRunningResponse' '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/audit: get: operationId: getAudit tags: - Database description: Returns a list of the most recent "modificationTimes" in long datetime format parameters: - $ref: '#/components/parameters/databaseLocationPathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/audit/jobs/{id}: get: operationId: getResourceAudit tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200GetAudit' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/stats: get: operationId: getStats tags: - Database description: Returns a summary of OFDB metadata and data points parameters: - $ref: '#/components/parameters/databaseLocationPathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/stats/jobs/{id}: get: operationId: getResourceStats tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200GetStats' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/fields: get: operationId: getFields tags: - Database description: Returns all the fields in the database(OFDB, OMS_OFDB, ECONOFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' post: operationId: addFields tags: - Database description: Allows users to add fields to existing OFDBs parameters: - $ref: '#/components/parameters/databaseLocationPathParam' requestBody: description: Data for creating fields in the database. required: true content: application/json: schema: $ref: '#/components/schemas/AddFields' examples: OFDB: description: The field schemas to be added value: data: - description: string iteration: 2D name: string size: 0 splitDirection: NONE type: INT codePageFlag: ASCII responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/fields/jobs/{id}: get: operationId: getResourceFields tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200GetFields' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/delete: post: operationId: deleteBulkItems tags: - Database description: Allows users to delete various combinations of symbols, dates, and fields from the desired OFDB requestBody: content: application/json: schema: $ref: '#/components/schemas/BulkDelete' parameters: - $ref: '#/components/parameters/databaseLocationPathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/delete/jobs/{id}: get: operationId: getResourceBulkDelete tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200BulkDelete' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/symbols: get: operationId: getSymbols tags: - Database description: Returns all the symbols in the database(OFDB, OMS_OFDB, ECONOFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - name: startsWith in: query description: Returns list of symbols which starts with mentioned string schema: type: string - name: endsWith in: query description: Returns list of symbols which ends with mentioned string schema: type: string - name: contains in: query description: Returns list of symbols which contains mentioned string schema: type: string - name: equals in: query description: Returns symbol which matches mentioned string schema: type: string - name: orderBy in: query description: Returns symbols in the mentioned sorted order, should provide asc or desc schema: type: string enum: - asc - desc responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' post: operationId: addSymbols tags: - Database description: Creates a new symbol with single/multiple dates for 3d database(OFDB). Creates a symbol for 2d database(OFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' requestBody: description: Data for creating symbol in the database required: true content: application/json: schema: $ref: '#/components/schemas/AddSymbols' examples: 3dOFDB: description: Object in content is mandatory and must contain date with atleast one iterative field value: data: - symbol: FDS content: - date: 20220106 price: '333' 2dOFDB: description: Object in content is optional and should contain fields of the OFDB value: data: - symbol: FDS content: - description: Your desired information price: '200' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '413': $ref: '#/components/responses/413Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' put: operationId: updateSymbols tags: - Database description: Updates existing symbols for single/multiple dates or adds a new symbol/date within a symbol if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' requestBody: description: Data for updating symbol in the database required: true content: application/json: schema: $ref: '#/components/schemas/UpdateSymbols' examples: 3dOFDB: description: Object in content is mandatory and must contain the field date and at least one iterative field value: data: - symbol: FDS content: - date: 20200202 price: '999' 2dOFDB: description: Object in content is OPTIONAL and should contain fields already existing within your OFDB value: data: - symbol: FDS content: - country: USA responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '413': $ref: '#/components/responses/413Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/symbols/jobs/{id}: get: operationId: getResourceSymbols tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200GetSymbols' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/symbols/{symbol}: put: operationId: updateSymbol tags: - Database description: Updates an existing symbol field value for single/multiple dates or adds a new symbol/date within a symbol if not present in 3d database(OFDB). Updates an existing symbol field value or adds a new symbol if not present in the 2d database(OFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/symbolPathParam' requestBody: description: Data for updating symbol in the database required: true content: application/json: schema: $ref: '#/components/schemas/UpdateSymbol' examples: 3dOFDB: description: Object in content is mandatory and must contain the field date and at least one iterative field value: data: - content: - date: 20200202 price: '999' 2dOFDB: description: Object in content is OPTIONAL and should contain fields already existing within your OFDB value: data: - content: - country: USA responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '413': $ref: '#/components/responses/413Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' delete: operationId: deleteSymbol tags: - Database description: Deletes all data specific to the symbol in both 2d and 3d database(OFDB). This includes all the dates related to that symbols in 3d database(OFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/symbolPathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '204': $ref: '#/components/responses/204Response' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/symbols/{symbol}/jobs/{id}: get: operationId: getResourceSymbol tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/symbolPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/PostRequestsSuccessCompleteResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/dates: get: operationId: getDates tags: - Database description: Returns all the dates in the database(OFDB, OMS_OFDB, ECONOFDB) parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - name: between in: query description: Returns list of dates which are between [start,end], dates should be in the respective order of start and end style: form explode: false schema: type: string - name: equals in: query description: Returns the date which matches given date schema: type: string - name: before in: query description: Returns list of dates which are before mentioned date schema: type: string - name: after in: query description: Returns list of dates which are after mentioned date schema: type: string - name: orderBy in: query description: Returns dates in the mentioned sorted order, should provide asc or desc schema: type: string enum: - asc - desc responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' post: operationId: addDates tags: - Database description: Creates a new date with single/multiple symbols for a 3d database(OFDB). parameters: - $ref: '#/components/parameters/databaseLocationPathParam' requestBody: description: Required data for creating date in the database. At least one iterative field is required otherwise it will throw 400. required: true content: application/json: schema: $ref: '#/components/schemas/AddDates' example: data: - date: 20220107 content: - symbol: FDS price: 444 responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '413': $ref: '#/components/responses/413Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' put: operationId: updateDates tags: - Database description: Updates existing dates for single/multiple symbols or adds a new date/symbol within a date if not present in 3d database(OFDB). parameters: - $ref: '#/components/parameters/databaseLocationPathParam' requestBody: description: Required data for updating date in the database required: true content: application/json: schema: $ref: '#/components/schemas/UpdateDates' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '413': $ref: '#/components/responses/413Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/dates/jobs/{id}: get: operationId: getResourceDates tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200GetDates' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/dates/{date}: put: operationId: updateDate tags: - Database description: Updates an existing date field value for single/multiple symbols or adds a new date/symbol within a date if not present in 3d database(OFDB). parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/datePathParam' requestBody: description: Required data for updating date in the database required: true content: application/json: schema: $ref: '#/components/schemas/UpdateDate' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '413': $ref: '#/components/responses/413Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' delete: operationId: deleteDate tags: - Database description: Deletes all data specific to the date in 3d database(OFDB). This includes all the symbols related to that date parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/datePathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '204': $ref: '#/components/responses/204Response' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/dates/{date}/jobs/{id}: get: operationId: getResourceDate tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/datePathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/PostRequestsSuccessCompleteResponse' '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/dates/{date}/symbols/{symbol}: delete: operationId: deleteDateFromSymbol tags: - Database description: Deletes data specific to the symbol and date from a 3d database(OFDB). parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/datePathParam' - $ref: '#/components/parameters/symbolPathParam' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '204': $ref: '#/components/responses/204Response' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/dates/{date}/symbols/{symbol}/jobs/{id}: delete: operationId: getResourceDateFromSymbol tags: - Database description: Deletes data specific to the symbol and date from a 3d database(OFDB). parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/datePathParam' - $ref: '#/components/parameters/symbolPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/202LongRunningResponse' '204': $ref: '#/components/responses/204Response' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}: get: operationId: getData tags: - Database description: Returns the data in the database(OFDB, OMS_OFDB, ECONOFDB) for the mentioned Symbol or Date. Atleast one parameter(Symbol/Date) is required. For a range of dates symbol parameter is mandatory. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - name: symbol in: query description: Returns data for the symbol mentioned. e.g:sym1 schema: type: string - name: date in: query description: Return data for the specific date or range of dates mentioned.e.g:[date1,date2] style: form explode: false schema: type: string - name: filterFields in: query description: "Can specify the fields on which you want to perform field filter operations e.g: [\"PRICE\",\"SECTOR\"]\n\nNote:\n\nThe request will respond with 400\n1. If fields which are not present on OFDB are given.\n2. If filterOps or filterValues query parameters are missing\n when filterFields is present.\n3. If number of values given for filterOps, \n filterFields, filterValues are different\n4. If exactly one of symbol or date query parameter is not provided.\n" style: form explode: false schema: type: string - name: filterOps in: query description: "Can specify the field filter operations which you want to perform e.g: [\"LT\", \"GTEQ\", \"CT\"]\nin respective order of values in filterFields query parameter.\n\nThe available field filter operations are :\n\nFor CHAR type fields:\n\n\"CT\" : contains\n\n\"SW\" : starts-with\n\n\"EW\" : ends-with \n\n\"EQ\" : equals\n\nFor NUMERIC type fields:\n\n\"GT\" : greater than\n\n\"GTEQ\" : greater than or equals\n\n\"LT\" : lesser than\n\n\"LTEQ\" : lesser than or equals\n\n\"EQ\" : equals\n\nNote:\n\nThe request will respond with 400 \n1. If operations other than the above mentioned are provided.\n2. If numeric operations are given to char type fields instead of char operations.\n3. If char operations are given to numeric type fields instead of numeric operations.\n4. If filterFields or filterValues query parameters are missing\n when filterOps is present.\n5. If number of values given for filterOps, \n filterFields, filterValues are different\n6. If exactly one of symbol or date query parameter is not provided.\n" style: form explode: false schema: type: string - name: filterValues in: query description: "Can specify the field filter values of the field filter operations e.g: [100, 20, \"AB\"]\nin respective order of values in filterFields and filterOps query parameters .\n\nNote: \n\nThe request will respond with 400\n1. If char values are given to numeric type fields.\n2. If filterFields or filterOps query parameters are missing\n when filterValues is present.\n3. If number of values given for filterOps, \n filterFields, filterValues are different\n4. If exactly one of symbol or date query parameter is not provided.\n" style: form explode: false schema: type: string - name: filterDatesOps in: query description: "Can specify the date filter operations which you want to perform e.g: [\"LT\", \"GTEQ\"].\n\nThe available date filter operations are :\n\n\"GT\" : after\n\n\"GTEQ\" : after or equals\n\n\"LT\" : before\n\n\"LTEQ\" : before or equals\n\n\"EQ\" : equals\"\n\nNote:\n\nThe request will respond with 400 \n1. If operations other than the above mentioned are given.\n2. If filterDatesValues query parameter is missing when filterDatesOps is present.\n3. If number of values given for filterDatesOps and filterDatesValues differ.\n4. If symbol query parameter is not provided.\n" style: form explode: false schema: type: string - name: filterDatesValues in: query description: 'Can specify the date filter values of the date filter operations e.g: [20200505, 20200303] in respective order of values in filterDatesOps query parameter. Note: The request will respond with 400 1. If invalid date values are given 2. If filterDatesOps query parameter is missing when filterDatesValues is present. 3. If number of values given for filterDatesOps and filterDatesValues differ. 4. If symbol query parameter is not provided. ' style: form explode: false schema: type: string - name: filterSymbolsOps in: query description: 'Can specify the symbol filter operations which you want to perform e.g: ["CT", "SW"]. The available symbol filter operations are: "SW" : starts-with "EW" : ends-with "CT" : contains "EQ" : equals Note: The request will respond with 400 1. If operations other than the above mentioned are given. 2. If filterSymbolsValues query parameter is missing when filterSymbolsOps is present. 3. If number of values given for filterSymbolsOps and filterSymbolsValues differ. 4. If date query parameter is not provided. ' style: form explode: false schema: type: string - name: filterSymbolsValues in: query description: 'Can specify the symbol filter values of the date filter operations e.g: ["ab", "xy"] in respective order of values in filterSymbolsOps query parameter. Note: The request will respond with 400 1. If filterSymbolsOps query parameter is missing when filterSymbolsValues is present. 2. If number of values given for filterSymbolsOps and filterSymbolsValues differ. 3. If date query parameter is not provided. ' style: form explode: false schema: type: string - name: sortFieldName in: query description: "Can specify the name of field with respect to which user wants to sort data \n\nNote:\nThe request will respond with 400, If a field which doesn't exist in the OFDB is requested" style: form explode: false schema: type: string - name: sortFieldOrder in: query description: "Can specify the order in which user wants to sort data with respect to sortFieldName query parameter \n\nNote:\nThe request will respond with 400, If value other than asc or desc is requested" schema: type: string enum: - ASC - DESC responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/{path}/jobs/{id}: get: operationId: getResourceData tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/databaseLocationPathParam' - $ref: '#/components/parameters/idPathParam' responses: '200': $ref: '#/components/responses/200GetData' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database: post: operationId: createDatabase tags: - Database description: Creates a 2d or 3d database(OFDB). Users will note that not every field requires all the parameters listed in the schema. Please review FactSet data types on the OA for further guidance. requestBody: content: application/json: schema: $ref: '#/components/schemas/DatabaseSchema' responses: '202': $ref: '#/components/responses/202LongRunningResponse' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' /database/jobs/{id}: get: operationId: getResourceDatabase tags: - Database description: Returns the end results of a long running request. The full URL is normally provided for you in the Location header of a finished long running response. parameters: - $ref: '#/components/parameters/idPathParam' responses: '200': description: Creates and responds with ofdb path headers: X-DataDirect-Request-Key: $ref: '#/components/headers/X-DataDirect-Request-Key' X-FactSet-Api-Request-Key: $ref: '#/components/headers/X-FactSet-Api-Request-Key' X-RateLimit-Limit: $ref: '#/components/headers/X-RateLimit-Limit' X-RateLimit-Remaining: $ref: '#/components/headers/X-RateLimit-Remaining' X-RateLimit-Reset: $ref: '#/components/headers/X-RateLimit-Reset' content: application/json: schema: $ref: '#/components/schemas/CreateDatabase' links: GetDataByPath: operationId: GetData parameters: path: $response.body#/path description: 'The `path` value returned in the response can be used as the `path` parameter in `GET /v1/database/{path}/data`. ' '400': $ref: '#/components/responses/400Response' '403': $ref: '#/components/responses/403Response' '404': $ref: '#/components/responses/404Response' '406': $ref: '#/components/responses/406Response' '429': $ref: '#/components/responses/429Response' '500': $ref: '#/components/responses/500Response' '503': $ref: '#/components/responses/503Response' components: schemas: AddDates: type: object properties: data: type: array items: type: object properties: date: type: integer description: Date unique to the database. example: 20220202 content: type: array items: type: object properties: symbol: type: string field: type: integer Symbols: type: array items: type: string example: FDS UpdateDate: type: object description: Set of fields along with symbol is mandatory to update the date. properties: data: type: array items: type: object properties: content: type: array items: type: object properties: symbol: type: string field: type: integer description: date has to be provide in case 3d OFDB with date and atleast one iterative field example: - content: - symbol: FDS price: 100 Fields: type: array items: type: object properties: description: type: string iteration: type: string enum: - 2D - 3D name: type: string size: type: integer splitDirection: type: string enum: - NONE - NORMAL - REVERSE type: type: string enum: - INT - FLOAT - DOUBLE - CHAR - LONG_CHAR - STRING - DATE codePageFlag: type: string enum: - ASCII BulkDelete: type: object properties: data: type: array items: description: Users may provide any combination of a symbol, date, and/or field to perform a bulk delete operation. For example, if a user provides both a symbol and a date within the same data point {} then the endpoint will delete the symbol for just that date. If they provide a symbol, date, and field then the endpoint will delete just that singular field entry point for that date for the given symbol. Providing singular entities within a {} will delete the complete data for that given value. type: object properties: symbol: type: string date: type: integer field: type: string example: - symbol: FDS - date: 20220202 - field: PRICE - symbol: AAPL date: 20230303 - symbol: TSLA date: 20240404 field: SHARES BulkDeleteArrayItemNested: oneOf: - type: object additionalProperties: type: array items: type: integer - type: array items: type: integer SuccessPostResponse: type: object description: Response format of any kind of post response properties: data: type: object properties: id: type: string description: id of the newly created resource DatabaseSchema: type: object properties: data: type: object properties: path: type: string example: CLIENT:this_is_a_test_.OFDB description: type: string example: A user would fill this with relevant information fields: $ref: '#/components/schemas/Fields' AddFields: type: object properties: data: $ref: '#/components/schemas/Fields' rolloverResponse: type: object title: Rollover Response properties: data: description: Array of `Database Rollover` objects. type: array items: $ref: '#/components/schemas/rollover' example: [] errorResponse: type: object title: Error Response properties: status: description: status type: string example: Bad Request timestamp: description: timestamp in YYYY-MM-DD HH:MM:SS.SSS type: string example: '2019-11-01 11:09:41.918' format: date-time path: description: The Endpoint path {package}/version/{endpoint} type: string example: /factset-prices/v1/prices message: description: The plain text error message type: string example: Validation Error subErrors: description: subErrors related to the error message. Null if not applicable. type: object properties: object: description: the operation ID type: string field: description: Parameter Field Name type: string message: description: Error message type: string rejectedValue: description: Rejected Values in an Array type: array items: type: string example: example_value Dates: type: array items: type: integer example: 20220202 BulkDeleteArrayItem: anyOf: - type: object additionalProperties: $ref: '#/components/schemas/BulkDeleteArrayItemNested' - type: array items: type: string BulkDeleteArray: type: array description: 'A list of the various backend responses needed for the bulk delete. These typically contain data points that failed to be deleted, and are in the order of: