Click or drag to resize

DataExchangeDataExchangeSqlImport Method

Note: This API is now obsolete.

The CodeMethod shall take a SQL statement and a SQL connection, and fetch all the data from the SQL Server and save them to a CSV file, and upload the CSV file to a new version of a DataExchange file. The Data Exchange should already have a file attached
Codemethod usage
Designed to be used in a process only (Yes/No) No
Action Object (data object type) N/A

Code method configuration must hold database connection and command information as well as the data exchange UId

Example of code method configuration:

Copy
<DataExchangeSqlImport>
 <CommandText>select a, b, c from tbl_d</CommandText>
 <ConnectionString>User ID=sa;Initial Catalog=SomeDatabase</ConnectionString>
 <DataExchangeUid>xxxx-xxxx-xxxx-xxxx-xxxx</DataExchangeUid>
</DataExchangeSqlImport>

Namespace:  Omada.OE.UtilityCodeAssembly
Assembly:  Omada.OE.UtilityCodeAssembly (in Omada.OE.UtilityCodeAssembly.dll) Version: 15.0.0.0
Syntax
C#
Copy
[ObsoleteAttribute("Use SQL Data Exchange")]
public bool DataExchangeSqlImport(
	CodeMethodInvokeContext context,
	int codeMethodConfigId
)

Parameters

context
Type: Omada.OE.ModelCodeMethodInvokeContext
Invoke context object
codeMethodConfigId
Type: SystemInt32
The id of the code method configuration

Return Value

Type: Boolean
true if OK
See Also