cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieve the data from the top-most tag without all the change logs while querying compiundemployee

Mofizur
Contributor
0 Kudos

Hello Team,

I only want to retrieve the data from the top-most tag without all the change logs while querying compoundemployee API. Is this possible?
<person>
<personal_information></personal_information>
<personal_information></personal_information>
<personal_information></personal_information>
<address_information></address_information>
<email_information></email_information>
<employment_information></employment_information>
<employment_information></employment_information>
</person>

I am expecting something like below

<person>
<personal_information></personal_information>
<address_information></address_information>
<email_information></email_information>
<employment_information></employment_information>
</person>

 

I am using below query to get the necessary data so that from there I can do the field mapping as per my target structure. SELECT person, personal_information, address_information, employment_information, job_information, email_information FROM CompoundEmployee WHERE last_modified_on >  to_DateTime('2024-02-20T01:00:00Z')

However I am facing some challenges when there are multiple tgas for similar category. For example above query gives me all the audit logs for personal_information ( all the changes) which is creating problems in my mapping in CPI - for the first record in target it is coming fine because it takes the data from the top most employee informaiton tag but for the second record onwards while mapping it takes emlpoyment information from the employment informaiton tag of the first record ( second, third and on ). 

 

Thanks,

Mofizur

Accepted Solutions (0)

Answers (0)