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.

i think its easier to creat a virtual column FILE.

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

CONTEXT() - AppSheet Help

1 Like

sorry…i just copied…my bad man…i really dont know why i couldn see it. many thanks…

1 Like