Wevo iPaaS dynamic storage¶

Dynamic storage is an application developed on the Wevo iPaaS platform that allows you to store spreadsheets and/or data structures, in order to keep records saved and to use them in your integration processes. Its functionalities are intuitive and make it very helpful. This page teaches how to use this tool.

Access dynamic storage¶

Under the Developer options, click Dynamic Storage. You will see the screen below.

Create a table¶

Click Add Table.

The dialog box that will be shown is pictured below. Configure the following fields:

1. Table Name: Insert a name for the table. Do not use spaces.

2. Description: Provide a brief description of the table.

3. Fields: Define which fields will make up your table.

   • Name: Insert a name for the field. The field name must not contain spaces, and the first character must not be a number.

   • Type: Choose which data type can be inserted in that field, whether Text, Number, or Boolean.

   • Search Key: Mark this checkbox if the field is to be a primary key.

   • Required: Mark this checkbox if the field cannot be left empty.

   • Add Field: Click the addition icon to add another field to your table.

   • Delete Field: Click the deletion icon to delete any field.

4. Save: Click this button to finish the creation of your spreadsheet.

Fill out a spreadsheet manually¶

There are two ways to insert data into the spreadsheet: either manually or through an integration flow. This section describes how to insert the data manually.

• Click Add Register.

  

• Insert the data into the spreadsheet by filling out the fields. If any fields are required, you may not leave them empty. When you finish, click the checkmark icon on the left. If the fields have been filled out correctly, you will see a success message on the bottom right letting you know that the new record has been added, as shown below:

  

Spreadsheet options menu¶

In the spreadsheet options menu, there are a few actions available to you. All options are shown and described below.

• Send to Email: This options allows you to send the spreadsheet you've created via email, which facilitates reusing the data contained in it for another process. To do so, add the email addresses (one or many) you want to send the spreadsheet to and click Send.

  

• Upload Spreadsheet: After the spreadsheet's fields have been created, you must feed the table with information. To do so, the data must be contained in a spreadsheet saved in your machine. Click Browse to pick the spreadsheet you wish to import.

  

  Important

  To prevent errors, it is important that the fields in the spreadsheet you are going upload match the ones you created in the platform. For instance, in the table being demonstrated in these screenshots, the spreadsheet would need to contain the Endereço ("Address"), Nome ("Name"), Telefone ("Phone Number"), and Email fields so the upload can occur correctly. Only files in the .xlsx format are allowed.

• Clean Table: When you click this option, you can delete all the records in the spreadsheet. To confirm that you want to do so, you have to manually type the word delete in the field shown below and click Confirm.

  

View options¶

On the dynamic storage home screen, where all your spreadsheets are listed, there is a column titled Options containing four icons, as shown below:

The icons and what they do are described below:

• View Items: By clicking this option, you can view all records in your spreadsheet.

  

• Logs Events: With this option, you can view changes made to the spreadsheets. The changes are shown as Events, such as Upload, Clean, or Deploy.

  

• Edit Storage: This options allows you to edit the fields of the spreadsheet, by either adding or deleting any fields. After making edits, click Save, then Deploy to update your spreadsheet.

  

• Delete Storage: In case you want to delete the spreadsheet altogether, click this option. It will require you to confirm that you want to delete it. Click Confirm and the spreadsheet will be deleted.