API json

[Yogita_Gaikwad1 (Yogita Gaikwad)]

can anyoneone tell me why this error is come

[B_H_Akshatha_Pai]

What is the type argument of your deserialize json? in properties pannel ?

Regards,

[vinitha_yachamaneni]

Hi @Yogita_Gaikwad1

jsonobject(“results”)(“key”).tostring

pass the required value in place of key

[Yogita_Gaikwad1 (Yogita Gaikwad)]

In property type of argument is object

[vinitha_yachamaneni]

@Yogita_Gaikwad1

can you make it as

newtonsoft.json.linq.Jobject should be the type of argument

[B_H_Akshatha_Pai]

It has to be of this type

Regards

[Yogita_Gaikwad1 (Yogita Gaikwad)]

Again it shows ssame error

[B_H_Akshatha_Pai]

There should be 2 values . please check (“results”) and another value

Regards

[Yogita_Gaikwad1 (Yogita Gaikwad)]

this is my json file

again same error is come

[B_H_Akshatha_Pai]

@Yogita_Gaikwad1
jsonObject(“results”)(0)(“name”)(“first”).ToString

This Results { } is in the form of an array , so name is present in the 0th index , in name we need the “first” feild so , jsonObject(“results”)(0)(“name”)(“first”).ToString
Regards

[Yogita_Gaikwad1 (Yogita Gaikwad)]

@B_H_Akshatha_Pai

sonObject(“results”)(0)(“name”)(“first”).ToString

[B_H_Akshatha_Pai]

show me the datatype of your jsonObject

Regards,

[Yogita_Gaikwad1 (Yogita Gaikwad)]

after the data type is changed error is gone but this error is come

[B_H_Akshatha_Pai]

Check out my xaml
Sequence - Json Details To Excel.zip (2.9 KB)
Regards,

[Yogita_Gaikwad1 (Yogita Gaikwad)]

This workflow is not open in my UiPath studio

[B_H_Akshatha_Pai]

why what happened ?

Can you send your older workflow let me check

Regards

[Yogita_Gaikwad1 (Yogita Gaikwad)]

[Sequence - Json Details To Excel.zip|attachment]

(upload://mXqfrtF2gFd8vFLQdOtwI4T70qT.zip) (2.9 KB)

[B_H_Akshatha_Pai]

Sequence - Json Details To Excel.xaml (14.3 KB)
Check this

[Yogita_Gaikwad1 (Yogita Gaikwad)]

again same error is come

[B_H_Akshatha_Pai]

kindly send your xaml