Json Array to data table using assign activity

Help Studio
1

error
error1920×1080 236 KB

i am facing this problem can anyone please help me

2

HI @santosh_sai

Check out the blog

Regards
Gokul

1 Like
3

Hi @santosh_sai

is DT of type string or Datatable? Please check that

cheers

4

May we ask you to share with the us the JSON / JSON Array sample data? Thanks

5

data table

6

data2.txt (1.4 KB)

7

grafik
grafik700×189 55.4 KB

myJObject("data").ToObject(Of DataTable)

myJObject | DataType: JObject - output form the Deserialize JSON Activity

8

@santosh_sai

Can you try this please

Newtonsoft.Json.JsonConvert.DeserializeObject(of datatable)(DJson("data").TOString)

cheers

9

in Addition and related to your screenshot:

Ensure that DT or the variable on which thge statement is assigned is of DataType: Datatable

10

i have followed the video but in the video in the assign activity i am facing the same problem which is data table cannot be converted to string

in the link that you have shared it is showing the information for a json string but not for a json array so i would like to request you to provide me the solution for the json array
thank you for your time

11

yes i have made it a data table variable only

12

i have tried the same but getting same error that data table cannot be changed to string could you provide another solution

13

show us your variable panel, defining the variable which is used on the left side from the assign statement

14

thank you all for your valuable time in trying to solve my problem
the mistake was DT was not data table variable but a string the error has gone

But i am facing another problem which is in continuation to this i request everyone to kindly provide me the solution to this
in this i have used excel process scope and followed by use excel file and followed by write data table to excel where
in the what to write field i am using DT (data table variable which i defined earlier )
there i am getting error as below

error2
error21920×1080 282 KB

i would like to request to provide me the solution to this

15

@santosh_sai

As I told already the type is string… good that you found that

Can you open the ‘What to write’ and see in advanced editor if something else is also got pasted

cheers

1 Like
16

Excellent @Anil_G what you mentioned is absolutely correct apart from DT something else was also pasted by me ,couldn’t know until it is opened in advanced editor. iam very much thankful to you for providing me the solution and being patient with my problem thank you so much

1 Like
17

variable data type i have mistakenly kept string what u said to check is correct thank you

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.