Object reference not set to instance of objectt

Unable to fetch “variables.customer”: “jessie” value into excel from below json response. Could you please help on this.

data.Rows(RowCounter).Item(“Customer”)=?

1 Like

Please show us the fetch code ?

There is no parameter key name “Customer” which resulted in object reference error . use variables.customer instead

i have fetch these values from response.

Hello @avnreddy007 ,

Are you using the json activities to get the values from the json. Object reference not set to instamce of object will through if you are trying to fetch the object which is not present .

It would be better if you can share the screenshot of flow which you have created and the requirement.

I have assigned some variables to fetch variables as shown in figure, but unable to fetch varaibles.customer value into excel its throwing error.



flow1

customer is just variable name to store variables.customer value.



flow1

Hey @avnreddy007

You posted a notepad image with JSON right ?

So you want to just fetch variables.customer from it ?

Thanks
#nK

yes @Nithinkrishna

1 Like

Okay clear @avnreddy007

So @avnreddy007

Just de-serialize your json first into a jObject

CStr((jObjVar("result")(0))("variables.customer"))

Thanks
#nK

Hello @avnreddy007 ,

Refer the below post. It can give some insights for you.

How to deserialize JSON in UiPath? | Aneejian

share u r mail id, we will connect once

1 Like

Please check your DM.

I have Below json response, I have extracted “short_description”: “Modify - BIIB Germany (SABR BO)”,But unable to extract “variables.customer”:“jasse” into excel.
Could you please help on this.
Below the json response.

1 Like

If you don’t mind, could you upload your workflow and the json response as a text file? It would make it easier for us to troubleshoot.

Hey @avnreddy007

Thanks, hope you got the solution.

Deserialize → DataTable → Filter → Write

Thanks
#nK