Add JSON data to DataTable

Help Studio
, ,
1

grafik
grafik1018×609 23.8 KB

I am trying all the time to get the information(Hours,Firstname,Lastname,project) from my json file and store it in a datatable between. Can someone help me? thanks in advance

2

Assumed the retrieval is working

  • on top of the XAML prepare an empty datatable with the build datatable activity and configure the needed columns
  • use add datarow activity for adding the data to the datatable within the for each after the Multiple Assign activity
3

Hi, do you mean build data table after the deserialize json array activity? My retrieval with Http request works and I get a json with a lot of information. but I only need these 4 infos.
regards

4

make it on begin at the xaml

5

grafik
grafik817×600 17.7 KB

like this?

6

grafik

7

grafik
grafik546×505 13.7 KB

feel free to adopt the column datatypes

grafik

8

grafik
grafik1082×638 39.7 KB

Thanks for the help, but I can only see tablename…
regards

9

yes, as we do not log out a datatable content in this way

  • in general we do debug and inspect the result

the content of a datatable as string representation we can use the output datatable activity

10

Thanks for your help :slight_smile: It works!

11

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