Small and medium business | Business Central, N...

CSV Buffer. Use more than 250 characters

(0) Share

Report

Posted on by AntonioTorre

566

Hi, I need to create a blob to upload info to an external app.

I am using CSV Buffer to create base data to upload which is pretty simple and cool.

Now I am facing a problem that CSVBuffer table "Value" field has a maximum lenght of 250 chars.

This works fine for most of the fields I need, but I am willing to create a very large field (to store a json stream) and this 250 chars limit makes it impossible.

I am thinking in extending table CSV Buffer with a "VALUE2" field up to 2048 chars (I think this is the limit) but I am not sure this will work and I am not sure how to mod CSVBuffer functions in order to deal with this new fields.

XMLPORT is not an option (too many and variable fields in structure I need to upload).

All responses (3)

Answers (0)

Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: CSV Buffer. Use more than 250 characters

I've clearly misunderstood. If you want to export as a blob then check this: docs.microsoft.com/.../export-function--blob-

Older code style but the principles may remain: www.olofsimren.com/.../
AntonioTorre 566 on at

Like (0)

Report

RE: CSV Buffer. Use more than 250 characters

Thanks Josh thats a nice approach, but I need to use a Blob type field to store very large data (a json file which can have 3 or 4 thousands chars. I am not sure how move that data in the blob field to a csv file
Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: CSV Buffer. Use more than 250 characters

Do you have to use that exact table? Can't you create your own based on that table? If you take a copy of the base app you can just number it in the custom range and add the extra fields you need.