Attachment URL information about a file, and save it into file in a table

AppSheet AppSheet Q&A
1

I need to save the URL of a file saved in google drive automatically, I created the following:

  1. Create a Workflow rule to create and save the file, inside body information i used <<_ATTACHMENTFILE_URL>> variable and it is working very well

  2. I create an action to save information in a file into a table, i used the http information as result of <<_ATTACHMENTFILE_URL>>, in this case I used concatenated formula to decoding every part of the url. I can decode part of http information, as following:
    CONCATENATE(
    “https://www.appsheet.com/template/getappfileurl?appName=Violeta-1900059&fileName=”,
    ENCODEURL(“Comprobante Aportación - Folio: “),
    [Folio Ingresos],
    ENCODEURL(“ - Nombre: “),
    [Nombre],
    ENCODEURL(“ - Copia: “),
    [Actualizar],
    ENCODEURL(“.pdf&appVersion=”),
    [1.001693],
    “&signature=”,
    [5a5fcfc6ce6fe8d4b0dffd0c3dc69d6b9e455a434e5ee71badfcd98f1221492860de85cbbbb03c93f80c82d8dbc5035f])
    However i don´t know identify:

  3. Version of my application, because this will be dinamic, in this case 1.001693

  4. signature: this is a dinamic information, in this case is “5a5fcfc6ce6fe8d4b0dffd0c3dc69d6b9e455a434e5ee71badfcd98f1221492860de85cbbbb03c93f80c82d8dbc5035f”

I was reviewing https://help.appsheet.com/en/articles/2744751-email-attachment-file-archiving, but i did not find anything to identify the two points below

Thanks a regards

2

I don’t understand what you’re asking of us.

3

I am asking two things:

  1. how identify currently application version in order to put into concatenate formula something like [_appversion], because this is dinamic

  2. How to identify the parámeter “&signature=.

This is the original url that i have it for one file, but this URL must be calculated dinamically, the last part of the url I don’t know how will be created, its means what is the value for &signature=

https://www.appsheet.com/template/getappfileurl?appName=[APPNAME]&fileName=[ATTATCHMENT NAME].pdf&appVersion=[APPLICATION VERSION]&signature=[88a9d20703519e877580164f7be1d47b1788c06869f08e4972ba69ed4cea2cf29b17cda0ae5ee142ca4455d25d1f0c70]

From &signature i don’t know what it is

Regards

1 Like
4

I reviewed and the last &signature it does not necesary, it is created automatically, only is necesary app version.

It is possible to introduce in the concatenate formula, the command to identify last application Version?

Regards

1 Like
5

I am not aware of a way to get the current app version programatically.

6

Thanks a lot for your help¡¡¡

1 Like
7

Hello I did it, I only create the URL until attachment name “.pdf” and it worked very well, was not necessary the Application version

Regards

1 Like