public URL file issue

im trying to make a public url for a PDF file, im planning to use this url to make a base64 file (for an API POST, to upload a file).can someone tell me whats going wrong please....

the steps.

step 1- created a Virtual column name: [Relatório de Insp]  type:file, appformula: "/06-Equipamentos/06.00 Inspeção de Equipamentos Trabalho em Altura/01-Relatórios Sem Assinatura/"&[IdEqp]&" - Relatório de Inspeção de Equipamento.pdf"  ...this formula points to the file local save (google drive)  appears to work since its possible to open the genereted workflow pdf file

step 2 - create a virtual column type:url, appformula:CONCATENATE(
"https://www.appsheet.com/template/gettablefileurl",
"?appName=", ENCODEURL(CONTEXT("Equipamentos-ACP-5563741")),
"&tableName=", ENCODEURL(CONTEXT("06.01 Cinto")),
"&fileName=", ENCODEURL([Relatório de Insp])
)

step 3 - disabled security options


 
Updating Media

but the link created is giving a error , BAD REQUEST.

 

 

Solved Solved
0 3 203
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

CONTEXT() is used nonsensically. What do you want to do there?

CONTEXT() - AppSheet Help

View solution in original post

3 REPLIES 3
Top Labels in this Space