Jump to content
  • 0

Get file URL in Select query



Hi, I would like to render a link to a stored file on a datapage tabular report. The file is not directly in the data source of the page so I need to get it using a SELECT query...

SELECT form FROM ns_tbl_client_forms WHERE client_fk = target.[@field:ce_tbl_Client_client_id] AND form_type_fk = '1HXYQIHS'

'form' is the name of the field where the file is stored.

The above query correctly returns the name of the file, example 'testfile.txt'

I do not know how to get from this to a correct link.

I notice that the links in other parts of the app are formulated using an ID for the file such as...


I don't see how to get from the file name 'testfile.txt' to the ID '3706886'

Any pointers would be appreciated..


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

That is correct, the only way would be using Filestor CDN or store the file externally. As with the standard file system, the files are saved in Caspio and when they are requested by a DataPage the url to the file is generated with a random identifier. It is like that for security reasons.

What I have done in one of my applications is to upload the files to Drive so I can share files externally. You can check it out here: 


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...