AL code for show all file of the sharing directory and import into table blob

 To show all files in a sharing directory and import them into a table's Blob field using AL code in Microsoft Dynamics 365 Business Central, you can use the `FileManagement` codeunit to iterate over the files in the directory, read their contents, and store them in the Blob field. Here's an example:

```AL

PROCEDURE ImportFilesFromDirectoryToBlob@1()

VAR

  FileManagement@1: Codeunit 419;

  DirectoryPath@2: Text[250];

  Files@3: List of [Text[250]];

  FilePath@4: Text[250];

  FileContent@5: Text;

  ImportTable@6: Record 50000;

  InStream@7: InStream;

  Blob@8: Blob;

BEGIN

  // Shared path of the directory containing the files

  DirectoryPath := '\\server\share\directory\';

  

  // Get a list of all files in the directory

  FileManagement.GetFilesFromDirectory(DirectoryPath, '', Files);

  

  FOR EACH FilePath IN Files DO BEGIN

    // Read the content of the file

    InStream.OPEN(FilePath);

    InStream.READTEXT(FileContent);

    InStream.CLOSE;

    

    // Assign the content to the Blob field

    Blob.CREATEOUTSTREAM(OutStream);

    OutStream.WRITE(FileContent);

    OutStream.CLOSE;

    

    ImportTable.INIT;

    ImportTable.BlobField := Blob;

    ImportTable.INSERT(TRUE);

  END;

END;

```

In this example, we utilize the `FileManagement` codeunit to work with file-related operations. First, we set the `DirectoryPath` variable to the shared path of the directory containing the files you want to import.

The `GetFilesFromDirectory` function of the `FileManagement` codeunit retrieves a list of all files in the specified directory. The retrieved file paths are stored in the `Files` variable.

We then iterate over each file path in the `Files` list. For each file, we open it as an `InStream`, read its content into the `FileContent` variable, and close the `InStream`.

Next, we create a new `Blob` variable and use the `CREATEOUTSTREAM` method to create an output stream for writing to the Blob. We write the file content to the output stream and then close the stream.

Finally, we initialize the target table (`ImportTable` in this example), assign the Blob content to the desired Blob field (`BlobField` in this example), and insert the record into the table.

Make sure to adjust the code based on the structure of your table and Blob field.

Remember to ensure that the shared directory is accessible from the server running Business Central and that the necessary permissions are set for accessing the shared folder and files within it.