I have problem with filterable fields from SuccessFactors in boomi.
In JobApplication i can see filterable field CountryCode.
But when I try to select it in fields for expression in filter tab I can't see it:
Can somebody help me?
You can try using the Set Properties shape and write your where condition in that rather than using the filter options in the profile. The most important fromDate and toDate will also not be available in the filter options. When usually directly input the where condition in the properties.
Thanks for your reply.
Is it possible to do Set Properties for field that have in SF type Picklist Option?
For example in first screenshot you can see "assessment" field and this field I can't see in filters too.
Obviosly when I try to update JobApplication field Assessment I have error in field format: from boomi i try to send string value.
I have not tried using JobApplication Odata before. But a field referencing a picklist cannot be updated with the description.
You need to get the corresponding picklist id from the system and copy that value into the assessment field.
Can you explain how i can filter query with DPP?
In query I try to set WHERE
Before connector call I create Set Properties shape with DPP assessment="blabla"
But when I try to test process there're all documents has null value in assessment field.
Thanks you very much!
Filter Process Property = WHERE : the 'WHERE' you set here is the name of the DPP.
So, your dynamic proccess property name should be WHERE and not assessment. Whatever you type in the parameters (to the right) is the actual where clause.
Properties to Set: Dynamic Process Property-WHERE
Parameters: assessment = 'blabla'
It should be single quote and not double.
Thanks you for your reply!
I make this changes in my process but have new error:
I try to filter by candidateId field because assessment has Picklist option type.
Settings for dpp:
In SF candidateId has filterable=true.
I have found problem it was my fault.
Previously i have check odata api in SF but need to check SFAPI. Field assessment or cancdidateId hasn't filterable attribute it was false.
Your solution is right. Thank you very much!
Retrieving data ...