Invoking integration client via program call trigger

Learn how to invoice integration client via program call trigger.

If you want to invoke CRM.interface client via Aurea CRM trigger you have to

  • create a Program Call trigger
  • set Program Name to http*
  • specify the endpoint in the first parameter (endpoint always means the full path to the workflow which should be executed)

In the example below

  • the endpoint of CRM.interface is MyServer/Interface_btb_81/workflows/synchronize
  • the settings are defined in the PE_settings.xml file
  • four fields (FI_StatNo, FI_SerNo, PE_StatNo, PE_SerNo) of the actual data record are passed as parameters to the workflow

Example of Program Call trigger (http* trigger)



The trigger in our example generates an invocation message which looks something like that:

http://MYSERVER/Interface_btb_81/workflows/synchronize?settings=PE_settings.xml&company_ StatNo=&company_No=15&person_StatNo=100&person_No=834

The PE_settings.xml in our example references a query template file which looks something like that:

Example of a query template file

<?xml version='1.0'?>
<request>
<query maxrecords='100'>
  <tables>
	<table tablename='Company'>
	  <table tablename='Person' flags='256'/>
	</table>
  </tables>
  <fields tablename='Company' fields='CoGrp,CoNo,Company,Country,FreeN1'/>
  <fields tablename='Person' fields='Sex,LastName,FirstName,FreeN1'/>
  <condition>
	<cond tablename='Company' fieldname='CoGrp' op='=' value='{company_StatNo}'/>
	<cond tablename='Company' fieldname='CoNo' op='=' value='{company_No}'/>
  </condition>
  <condition>
	<cond tablename='Person' fieldname='PeGrp' op='=' value='{person_StatNo}'/>
	<cond tablename='Person' fieldname='PeNo' op='=' value='{person_No}'/>
  </condition>
</query>
</request> 

The parameters provided in the invocation message are merged into the query template file. During this merge the placeholders -which are marked with {parameter name} (e.g. {company_No})- are replaced by the matching values.

In our example value='{company_No}' is replaced by value='15' (since the parameter provided in the invocation message is company_No=15).