Get All Data Store Attributes
get
/rest/v16/extract/dataStores/{dataStoreName}/attributes
Use this endpoint to return the list of data store attributes available for extract.
Request
Path Parameters
-
dataStoreName(required): string
Data Store Name corresponds to the unique name returned by the /extract/dataStores endpoint
Response
Supported Media Types
- application/json
Default Response
Returns a list of datas store attributess available for extract
Root Schema : extractData_DataStoreAttributesListResponse
Type:
Show Source
object
-
additional:
object additional
Additional Properties Allowed: additionalProperties
-
items:
array items
Examples
The following example shows how to return the list of data store attributes available for extract by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.
curl - X GET - i - H "Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQg" - H "Content-type: application/json" https://sitename.oracle.com/rest/v16/extract/dataStores/oraclecpqo-transaction-DOCUMENT/attributes
Response Body Sample
{ "items": [{ "id": 36893314, "attributeVarName": "_document_number", "label": "Document Number", "description": "Unique doc number to be used as document identifier in a process", "isPrimaryKey": "true", "type": { "lookupCode": "CmTextAttribute", "displayValue": "Text" }, "additional": { "isStandardComponent": "true" } }, { "id": 36894810, "attributeVarName": "annualValue_l", "label": "Annual Value (Net)", "description": "The annual contract value of the recurring charges on this line.", "type": { "lookupCode": "CmCurrencyAttribute", "displayValue": "Currency" }, "additional": { "isStandardComponent": "true" } }, { "id": 36893336, "attributeVarName": "_price_book_var_name", "label": "Price Book Variable Name", "description": "Variable Name of the Price Book used to get the price for this line item", "type": { "lookupCode": "CmTextAttribute", "displayValue": "Text" }, "additional": { "isStandardComponent": "true" } }, { "id": 36894832, "attributeVarName": "cancelReason_l", "label": "Cancel Reason", "description": "The reason why the customer canceled this line.", "type": { "lookupCode": "CmMenuAttribute", "displayValue": "Menu" }, "additional": { "isStandardComponent": "true" } }, { ... }, { "id": -1, "attributeVarName": "_bs_id", "label": "BsId", "description": "BsId", "isPrimaryKey": "true", "type": { "lookupCode": "CmNumberAttribute", "displayValue": "Integer" }, "additional": { "isStandardComponent": "true" } } ], "additional": { "dataStoreName": "oraclecpqo-transactionLine-DOCUMENT" } }