JSON Error (Reading Values from Excel and updating using PATCH)

[marina.dutta]

Hi All,

Need help for the JSON error.

I am updating values in HTTP (Patch Request) . I already have Json template that I am replacing the values .The bot should read the Excel, and In place of Quotenumber should update Q29530,Q30219etc and Mismatched Data with Scheduling&Delivery,OpportunityId,OpportunityId etc. I am getting an error as

[Anil_G (Anil Gorthi)]

@marina.dutta

Please use deserializa json array activity

As per error the input json string you are giving is a json array and not jobject

Cheers

[marina.dutta]

@Anil_G

I need to update values from the column Mismatched Data. This column has sometimes single value and sometimes multiple values separated by comma. Here I am going wrong.

How should the JSON template be?Something below .My key has value which may contain multiple values separated by comma. For example

If I want to make the template is the below one correct?

[Anil_G (Anil Gorthi)]

@marina.dutta

Why are you using those square brackets?

As per postman a plain string with comma separation is needed…use it the same way

Cheers