ODBC Driver for Oracle Sales

Build 24.0.9060

CreateSchema

Creates a schema file for the specified table or view.

This procedure can be used to generate schema files for custom objects. All the available inputs are required:

  • TableName - This should match the API name of the custom or standard object. For example: for the Account(s) standard object this value should be "accounts".
  • FileName - The full file path and name of the schema to generate. For example: C:\\Users\\Public\\Documents\\Accounts.rsd
  • ApplicationType - The application where the object exists. in the Oracle Sales UI, this field correspond to the applications found by going to Navigator - Application Composer - Application. The valid values for this field are "Common", "Sales", "CRMRestApi", or FSCMRestApi. Note that to modify custom objects, the application should be in sandbox mode.

Input

Name Type Required Description
TableName String True The name of the table or view. Ex: 'accounts'
FileName String False The full file path and name of the schema to generate. Ex: 'C:\\Users\\User\\Desktop\\Accounts.rsd'

Result Set Columns

Name Type Description
Result String Returns Success or Failure.
Filedata String The generated schema encoded in base64. Only returned if FileName and FileStream is not set.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060