HCI Splitter doesn't work properly

[former_member75550]

Hi,

I've tried to configure the HCI splitter in several ways, but with no result.

Previous situation

capture1.png

Desired situation

capture2.png

However what I get the same result as the previous situation.

capture3.png

The HCI configuration is:

capture4.png

The content modifier value /AbsenceRegistrationRequest/AbsenceRegistration/AbsenceRegistrationRecord

capture5.png

The other content modifier is set on:

capture6.png

Does anyone have tips?

KR,

[Sriprasadsbhat · Accepted solution]

Hello Assarrar,

If you want to split it for every "AbsenceRegistrationRecord" then use Iterative Splitter with below configuration.

Regards,

Sriprasad Shivaram Bhat

[former_member75550 · Accepted solution]

Hi Sriprasad,

I have accidentally added the question on Answered, but the configuration doesn't work. I get the same output with the general splitter.

I have added AbsenceRegistrationRecord, /AbsenceRegistrationRecord and /AbsenceRegistrationRequest/AbsenceRegistration/AbsenceRegistrationRecord. None works.

capture10.png

Kr,

Massarrar

[former_member75550]

<Hi Sriprasad,

For every AbsenceRegistrationRecord I must add the absencerecords in SF EmployeeTime entity.

I can have several AbsennceRegistrationRecords. so I need to Loop for every record and upsert it to the SF system.

How every I try to configure the Loop process call, but I gives me errors.

capture11.png

capture12.png

KR,

Mostafa

[former_member75550]

Splitter wihout gather doesn't work

[Sriprasadsbhat]

Hello Assarrar,

Splitter without gather also works,but it is completely depends on your requirement.

Regards,

Sriprasad Shivaram Bhat

[former_member75550]

Hi Sriprasad,

Indeed you are right. What is the best practice in this case?

To use the Loop process call or the splitter for calling Odata requests in SF.

Kr,

MAssarrar

[Sriprasadsbhat]

Hello Assarrar,

What is the scenario or what exactly you are trying to achieve in this flow ,so that I can help you with my understanding.

Regards,

Sriprasad

[former_member75550]

Hi Sriprasad,

I have accidentally added the question on Answered, but the configuration doesn't work. I get the same output with the general splitter.

I have added AbsenceRegistrationRecord, /AbsenceRegistrationRecord and /AbsenceRegistrationRequest/AbsenceRegistration/AbsenceRegistrationRecord. None works.

capture10.png

Kr,

Massarrar

[Sriprasadsbhat]

hello assarrar,

It is working fine for me for the above pasted configuration( refer my earlier response )

Input XML:

<AbsenceRegistrationRequest>
	<AbsenceRegistration>
		<SystemDate>2017-09-22T00:00:00.000Z</SystemDate>
		<userId>1</userId>
		<AbsenceRegistrationRecord>
			<timeAccountType/>
			<timeType>0100</timeType>
			<startDate>2017-09-12T00:00:00.000Z</startDate>
			<endDate>2017-09-12T00:00:00.000Z</endDate>
			<quantityHours>2.00</quantityHours>
		</AbsenceRegistrationRecord>
		<AbsenceRegistrationRecord>
			<timeAccountType/>
			<timeType>0120</timeType>
			<startDate>2017-09-12T00:00:00.000Z</startDate>
			<endDate>2017-09-12T00:00:00.000Z</endDate>
			<quantityHours>2.00</quantityHours>
		</AbsenceRegistrationRecord>
	</AbsenceRegistration>
</AbsenceRegistrationRequest>

Output XML 1:

<AbsenceRegistrationRecord>
	<timeAccountType/>
	<timeType>0100</timeType>
	<startDate>2017-09-12T00:00:00.000Z</startDate>
	<endDate>2017-09-12T00:00:00.000Z</endDate>
	<quantityHours>2.00</quantityHours>
</AbsenceRegistrationRecord>

Output XML 2:

<AbsenceRegistrationRecord>
			<timeAccountType/>
			<timeType>0120</timeType>
			<startDate>2017-09-12T00:00:00.000Z</startDate>
			<endDate>2017-09-12T00:00:00.000Z</endDate>
			<quantityHours>2.00</quantityHours>
</AbsenceRegistrationRecord>

Could you please paste input XML and expected output from Splitter (it would be great and easy to replicate if you paste XML [ Masking confidential data ] instead of screenshots of the data ).

Regards,

Sriprasad Shivaram Bhat