Get files metadata – Solvexia

In this article, we will go through the Get files metadata file instruction and show you how to set it up in your process.

Introduction & Background

Use the "Get files metadata" file instruction to get information about files in your process. This instruction is useful if you want to control the workflow of your solution based on the incoming files or create extra audit controls.

This file instruction allows you to get the following information about files:

Column #	Metadata	Data Type	Description
1	File ID	String	The ID that is used to identify the file in SolveXia.
2	File Name	String	The name of the file.
3	File Extension	String	The file extension of the file.
4	File Size in Bytes	Number	The size of the file in bytes.
5	File URL	String	The link to the file in SolveXia.
6	File MD5	String	The MD5 hash of the file is a unique code generated from any piece of data, used to verify that the data hasn’t been altered .
7	Date Modified	Datetime	The datetime in UTC of when the file was last modified.
8	Last Modified By	String	The username of the person who last modified the file.

Set up and run the "Get files metadata" file instruction

1. Create an instruction "Get files metadata".

2. In the "source" section, link the file(s) you want to get information about.

3. In the "target" section, link an Excel file and specify the sheet name and cell reference to which the metadata should be copied.

4. Additionally, you can configure the list of files to be sorted by the file name in ascending or descending order. Otherwise, set the option to "None" to list the files in the order they are linked in the step.

5. Tick the checkbox "Include header with file metadata titles" if you want to include the column titles for each file metadata property.

View Results

After running the step, view the result by clicking "View" the target Excel file.

You will have a list of the source file's metadata in the target Excel file.