Hello,
I'm looking for a way to access the data (file) uploaded through the File_Upload field of a Zoho Creator form. Then, I would like to upload this file to workdrive or any third application.
I succeeded getting the data with a public URL :
"
https://creator.zoho.eu/file/<app_owner_name>/
<app_link_name>/
<report_link_name>/REPORT_ID/File_upload/download/
<view-perma>?filepath=/ZOHO_INTERNAL_FILENAME;"
So I can post it to workdrive of any other third party application.
However, this means that all the data related to this report MUST be public. This is not an option. As expected, if the link is not public, Workdrive or other cannot open the link to the file.
As alternative, I created a portal to control user access and tried the associated URL :
"https://
<owner_domain>.
zohocreatorportal.eu/file/<app_owner_name>/
<app_link_name>/
<report_link_name>/REPORT_ID/File_upload/download?filepath=/ZOHO_INTERNAL_FILENAME;"
In this case I tried to include basic authentication (login & pwd of the portal user) in the HTTP Header of the InvokeURL command but it doesn't work. As response to the HTTP request, I get a webpage requesting the credentials (login & password). So, probably, this basic authentication scheme through HTTP Header is not allowed or I did a mistake. Could you share an invokeURL example with the headers with this authentication method ?
Finally, I tried to use authtoken method with the private URL using zoho creator token with scope creatorapi :
"
https://creator.zoho.eu/file/<app_owner_name>/
<app_link_name>/<
report_link_name>/REPORT_ID/File_upload/download?filepath=/ZOHO_INTERNAL_FILENAME;"
This is not working, again, I get a webpage requesting the credentials (login & password). I checked my connection with this token using the other Zoho Creator endpoints (List applications, List report and even List File_Upload address). But I don't succeed using the token in a Header with the above URL or with authtoken directly in the URL.
Could you help me if this method ?
Maybe another method would be to use OAuth2 but I haven't see any documentation on this for accessing zoho creator.
Many Thanks.