Skip to Content
0
Oct 04, 2019 at 04:01 PM

how to combine the message of the same employee.

253 Views

Dear exports,

I am using the CPI to get data from the SF.But I am trying to combine some message of the same employee.

Now I am getting the data of the entity "PerPhone",and it returned me the record like below, each person's each phone number is one record.And some employees may have two business phone numbers, and it will return two records to me.But I want to combine them like into a same record and split the phone number with the ",".Just like below.

original return phone number(assume the employee have two business phoneNumbers):


the format I hope it looks like:

{

"emp_id":"Test_Import",

"Business":

{ "phoneNumber1","phoneNumber2"},

.....

}

Any Suggestions will be appreciated!!

Regards,

Christy.

Attachments