Page 1 of 1

File to Database Binary Column

Posted: November 3rd, 2021, 5:07 pm
by JefferyD
When trying to work with binary data or when using the SaveBinaryToFile service, you can utilize the file type when inserting or updating database records. When using the Update or Insert database services and setting the value type to "File", the contents of the Val node of the value should be a file path that will then be used to determine what file to copy to the database as a binary object.

Note: The file must exist in the application. If it doesn't, then it will need to be created or copied to the correct location using the file and folder services.

In this example, the file path is retrieved directly from the GetFiles service which ended up as "C:\EASYProcess51\Platform\DV\Applications\21000496\DownloadBLOB\download_blob_buffer.bin". Any file type or file path can be used as long as a valid file is found and the file path is accessible.
FileTypeUpdate.PNG
FileTypeUpdate.PNG (74.8 KiB) Viewed 6087 times
FileTypeUpdate.PNG
FileTypeUpdate.PNG (74.8 KiB) Viewed 6087 times