Workday - User Import - USERATTRIBUTEJSON

[Houssem93]

Hello,

I am working on the integration of Workday in EIC (24.2) as an authoritative source of users.

I have two RAAS connections. The first one is to import the present state of workers and the second one is to import the future state of workers.

In both connections, I am using the <User Attributes> section to store the multiple position that a worker can have.

In the "Present" import, I have configured the USERATTRIBUTEJSON as below: 

{
"UserAttributes": {
"Category": "wd:Position_ID_P~#~string",
"Title":"wd:Position_Title_P~#~string",
"Companyname": "wd:Brand_Name_P~#~string",
"Organization": "wd:Cost_Center_P~#~string",
"Country": "wd:Country_from_Pos_P~#~string"
}
}

In the "Future" import, I have configured the USERATTRIBUTEJSON as below: 

{
"UserAttributes": {
"CATEGORY": "wd:Position_ID_P~#~string",
"F_title":"wd:Position_Title_P~#~string",
"F_companyname": "wd:Brand_Name_P~#~string",
"F_startday": "wd:Job_Data.wd:Effective_Date~#~string",
"F_ORGANIZATION": "wd:Cost_Center_P~#~string",
"F_COUNTRY": "wd:Country_from_Pos_P~#~string"
}

}

My need: To store in this section the positions' information from the present AND from the future. To do this, I have named the attributes differently in the USERATTRIBUTEJSON.

Unfortunately when an import runs, all the "User attributes" section is overwritten by the USERATTRIBUTEJSON configuration in the import.

--> Is it possible to avoid this overwriting please ?

Thanks for your help !

Regards,

Houssem 

[sudeshjaiswal]

Hello @Houssem93,

Is `F_*` a custom property, or where are these attributes coming from?
Yes, it will overwrite the attributes if you use the same attribute. To avoid this, you need to use a different customproperty attribute.

Thanks.

[Houssem93]

Hello @sudeshjaiswal ,

Thanks for your response. The attributes that I am mentioning are not from "users" table. 

These attributes are generated and stored in the "user_attributes" table .

In "USERATTRIBUTEJSON" from Workday connector, we define the mapping and the names of these attributes.

Since I am having two workday connectors with two different configurations of the "USERATTRIBUTEJSON" section, my observation is that these attributes are overwritten.

--> Is it possible to avoid this overwriting ? 

Regards

[rushikeshvartak]

ideally this support lets say contractors data coming from different source and employees from different source , 

[sudeshjaiswal]

Hello @Houssem93 ,

Can you please share the screenshot of the first import and when you run the second import.
Is the label also getting updated along with the data or is it data only getting overwritten?

Thanks

[Houssem93]

Hello @sudeshjaiswal ,

The label is also getting updated. Please find attached the screenshots of the section after the 1st import and the 2nd import.

Thanks for your help!

Regards

  

[sudeshjaiswal]

Hello @Houssem93,

Let me verify this internally and will keep you posted on this.

Thanks.

[Houssem93]

Hello @sudeshjaiswal ,

Any updates from your side please ? 

Thanks !

[NM]

Hi @Houssem93 , I don't think it is possible to exclude those .. can you share your connector config ss