Object reference not set to instance of objectt

Help Activities
, ,
1

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

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

ress
ress1021×469 58.6 KB

1 Like
2

Please show us the fetch code ?

3

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

4

i have fetch these values from response.

sss
sss1231×160 29 KB

5

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.

6

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

f2
f2805×398 26.9 KB

f3
f3896×348 28.1 KB

flow1

7

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

f2
f2805×398 26.9 KB

f3
f3896×348 28.1 KB

flow1

8

Hey @avnreddy007

You posted a notepad image with JSON right ?

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

Thanks
#nK

9

yes @Nithinkrishna

1 Like
10

Okay clear @avnreddy007

11

So @avnreddy007

Just de-serialize your json first into a jObject

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

Thanks
#nK

12

Hello @avnreddy007 ,

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

How to deserialize JSON in UiPath? | Aneejian

13

share u r mail id, we will connect once

1 Like
14

Please check your DM.

15

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.

ress
ress1021×469 58.6 KB

1 Like
16

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.

17

Hey @avnreddy007

Thanks, hope you got the solution.

Deserialize → DataTable → Filter → Write

Thanks
#nK