how to apply where condition on upsert query

[pmhatre12]

HI expertise
i want to upsert payroll id for particular country in successsfactor . so how to apply where condition in upsert query ?

thanks
pranita

[philippeaddor]

Hi Pranita

How does your payload look like? Basically, the upsert request needs a payload in a specific format. In there, you pass the URI of the object that you want to update, and in there you specify the parameters in parenthesis in the way I mentioned in the commend before. See here: https://blogs.sap.com/2019/12/18/update-employees-records-from-different-entities-using-odata-batch-...

Please mark as Accepted if the question is answered by this.

Philippe

[philippeaddor]

Hi,

Did you try to specifc the object by adding the key fields behind the resource path in parentheses? Like e.g.

EmpCompensation(seqNumber='123', fieldB='abc')

[pmhatre12]

Hi Philippe
this method is not working any other solution

[philippeaddor]

Can you show what you have tried and especially what the error was? I believe my suggestion only applies to queries, not updates, sorry.