Add data row activity

i am using http activity to extract data from a web service . then i have used deserialize json array activity . after that i need to export the entire data in data table . there i have used build data table activity with 4 columns then i have used add data row activity where my workflow is throwing error : Object reference not set to instance of an object in add data row activity . Please help me out with this. where am i missing?

When u are using add data row maybe data is not available in that row which you trying to add?
check all data in message box before adding data row

Hi @Ankita121 r u using arrayrow or datarow in add datarow activity?

@Ankita121, Just initialize data table before using it.

e.g. Use Assign Activity with dt = new DataTavle()

@Ankita121

Object reference error will occur when there is null data or incorrect type of passing values, so better to check the data is correct

Thanks

i am using arrayrow

ok i will check with this one

i am using add data row activity inside for each loop. When i am reading dat in msg box using item.ToString is giving me the result.
Basically i need to extract the entire result in data row one by one. how can i do that?

what exactly data present in that Item?
as we know for add data row u need data row or array?
so check whether that data which u r passing in data row is of datatype- data row

i have passed data through arrayrow property in add data row activity @ImPratham45

Then check the array has all values present inside by using message box before add data row

yes it has. I have checked with the message box activity .

can you share your workflow?

this is solved now. Thank you everyone for your help@ImPratham45 , @Srini84, @Bhavik_Solanki, @Tushar_Karkera.

1 Like

Hi Ankita, please check this demo may help you: