Studio unable to read large size JSON/Text file

Help Studio
, ,
1

Hi, I am trying to read a large (>22 MB) JSON file using the Read Text File activity. After executing the process, it can read only 645 lines, but the file has 1000000 lines. (Confirmed by writing this text to a new text file.)
Please help me to read a complete JSON file with all 1000000 lines.

Thank you.

2

Had you tried?

3

Hi @Guru_Koli21 ,
use invoke code to read the test file
Reading/Writing Large Files VB.NET - Stack Overflow

Regards,
Arivu

4

Hi,

Can you try this VB.NET code below in Invoke Code to solve this issue?

Imports System.IO

Dim jsonContent As String = ""

Try
    Using sr As New StreamReader("YourPath.json")
        jsonContent = sr.ReadToEnd()
    End Using
Catch ex As Exception
    Console.WriteLine("An error occurred: " & ex.Message)
End Try

Console.WriteLine(jsonContent)

Regards,
Kardelen

5

Thanks for the solution, Its working fine.

6

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