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

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

Solved Solved
0 6 390
1 ACCEPTED SOLUTION

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

View solution in original post

6 REPLIES 6

Steve
Platinum 4
Platinum 4

I donโ€™t understand what youโ€™re asking of us.

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

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

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

Thanks a lot for your helpยกยกยก

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

Top Labels in this Space