Design

Back Next

SQL query response format

In a data access service connector, the XML response for single and multiple SQL queries begins with the

multiDataAccessResponse

tag.

The following sample snippet shows the format as the process or data access service output:


<multiDataAccessResponse xmlns:aetgt="http://schemas.informatica.com/socrates/data-services/2014/05/business-connector-model.xsd"
 xmlns:bconn="http://schemas.informatica.com/socrates/data-services/2014/05/business-connector-model.xsd">
	<dataAccessResponse>
		<result>
			<statementId>SQL Name 1</statementId>
				<row>
				<updatedRows>0</updatedRows>
				</row>
		</result>
		</dataAccessResponse>
		<dataAccessResponse>	
			<result>
			<statementId>SQL Name 2</statementId>
				<row>
				<updatedRows>1</updatedRows>
			</row>
		</result>
		</dataAccessResponse>
</multiDataAccessResponse>

The following sample snippet shows the XML format as the response payload:


<multiDataAccessResponse>
	<dataAccessResponse>
		<result statementId="SQL Name 1">
			<row>
			<updatedRows>0</updatedRows>
			</row>
		</result>
	</dataAccessResponse>
	<dataAccessResponse>
		<result statementId="SQL Name 2">
			<row>
			<updatedRows>1</updatedRows>
			</row>
		</result>
	</dataAccessResponse>
</multiDataAccessResponse>

Defining Actions

Download Guide

Watch

Comments

Cloud Application Integration Homepage