2023-07-17 04-42-12
Karthick Balaji
26Views
2Comments
I want to do bulk insert from text file that file contains json formt
Question
Reactive
Application Type
Reactive

Hi team 

I new for outsystems i have one issue actually I didn't work on bulk insert

Now I need to do bulk insert the data to my local entity. 

But actual thing I have data in the form json format but that is in text extension. Also I need to do use for timer. Because there is no UI. To upload file so that i have added that file under resource


Also I am converted that file to text but my actual name of attributes are different in my local entity attributes names are different for your reference I have attached the text file along that attributes naming conversion 


Can you anyone help me 🙏 to solve this is issue.. 


Thanks and regards 

Karthick 

StagingTableDesign.xlsx
portal orders - 20230829.txt
0
0
02 Sep
2023-05-25 14-12-43
Arun Rajput
Champion

Hi @Karthick Balaji 

Convert Json to list using Json Desrialized action inside the timer

Now use foreach loop and bind with Json Desrialized action list or inside the loop assign list value in respect attributes of table then use create function of table just below of the assignment for creating records 

Best

Arun

0
0
02 Sep

but actually i dont need to use for each loop this is actual problem in this case so only im planned to use bulk insert forge component can you guide me to achieve this one.



thanks 

karthick

0
0
02 Sep
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.