Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved ExportJson Size Limit

  1. Issue
0
Votes
Undo
  1. Joe Hess
    Joe Hess
  2. PowerBuilder
  3. Monday, 13 February 2023 22:27 PM UTC

Is there a limit to the size of a JSON created with ExportJson? I have an application where I push a JSON containing transaction data up to the ftp site of an online service. This has been working fine until a few days ago. I discovered ExportJson was returning null. If I reduce the number of rows exported, the function returns the JSON. To make sure it was not related to data, I exported the first 85% of the rows and the last 85% of the rows successfully. 

It is not tied to the number of rows because the exact number of rows I can export varied. 

I saved the data that successfully exported as a JSON to a text file (SaveAs). The size of the file was ~28Mb. For reference, the number of rows that would export was around 340,000.

 

Regards,

Joe Hess

 

Error while running the application
How to view Outlook .msg in the application, e.g b...
Accepted Answer
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 14 February 2023 04:27 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Joe,

When PB processes Json, for JsonParser/JSONGenerator/JsonPackage objects, as well as DW.ExportJson(), the maximum size is 20MB Json file or 100,000 lines of data. Of course, this limit may vary slightly depending on the environment of the machine.

https://docs.appeon.com/pb2022/objects_and_controls/JSONParser_object.html 

 

Regards,

Ken

Comment
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.