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 Cloud 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 | Accepts Output Streams | Description |
| TableName | String | True | False | The name of the table or view. Ex: 'accounts' |
| FileName | String | False | False | The full file path and name of the schema to generate. Ex: 'C:\\Users\\User\\Desktop\\Accounts.rsd' |
| FileStream | String | False | True | An instance of an output stream where file data is written to. Only used if FileName is not provided. |
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. |