on 01-12-2019 12:08 PM
Hi Experts,
I have a scenario, wherein I am getting a CSV file with a few fields. I want to manipulate the data in successfactors based on one of those fields. I am able to convert the data in XML using CSV to XML converter and I am able to filter out the field from input data, based on which I need to manipulate the SF data. But now I have the following challenges in the given order:
1. How to poll the data from successfactors based on that field? Which design time component shall I use?
2. Once I get the the data relevant to a particular field value (as given in input CSV), how do i upsert Data for other fields in the same entity?
Example use case for more understanding: I have a field named 'Status' in entity "JobRequisition" entity whose current value in SF recruitment is 'new'. From the input csv I get 'JobReqId = abc'. Now I want to change the 'Status' of this JobReqId to lets say 'in progress'. Now how do I poll data thats corresponding to JobReqID 'abc' from entity Jobrequisition in SF?
If I get that corresponding data, how do I change value of the 'Status' field to 'In progress' in the same entity?
Any leads would be appreciated on this.
Thanks in advance.
Regards,
Rishabh
Hello Rishab,
You can use content enricher followed mesaage mapping to achieve the same.
Regards,
Sriprasad Shivaram Bhat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you please check path in original message of content enricher where I could see in path also reqId (iif its field name you should remove it) present.
Regards,
Sri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Helo Rishab,
Could you please share the channel telated to content enricher.Channel must have requisition id(whatever u give in content enricher)
Regards,
Sr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sriprasad,
The channel is successfactors. I am querying the data as per the attached snip3.jpg
Please take a look/
Thanks & regards,
Rishabh
Hello Sriprasad,
I have been trying to use Content enricher but thats not helping at all.
The Use-Case:
I am getting a Requisition Id from a CSV file. Based on this ReqID I need to poll JobRequisition entity and find the same Jobrequisition ID and manipulate data against it, like manipulating the 'status' field.
Please see the attachment of how my Integration flow looks like.snip.jpg .
I first get the data from SFTP and convert the same in XML in the interest of enriching it with SF data in Content enricher step. Please check my Content enricher config in the snip2.jpg .
After this step when i check the payload with the help of a script, its just showing me the elements of CSV file only. I dont see the 'Status' field in it.
Any suggestions on how can I proceed on this?
Regards,
Rishabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. How to poll the data from successfactors based on that field? Which design time component shall I use?
To poll the data, you can use a request-reply step and use successfactors adapter. The data that you polled can be modified using message mapping or groovy script before you upsert it back to successfactors.
2. Once I get the the data relevant to a particular field value (as given in input CSV), how do i upsert Data for other fields in the same entity?
Again to upsert the data back to Successfactors, you use the request-reply step.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.