Jump to content
  • 0

Bulk Import of files to be linked to file field


vidierre
 Share

Question

I have a Candidacy table with some info field and a file filed. Normally candidates use a datapage to filli-in their data about a self evaluation and attach their resume as a PDF file. But i got also from other sources an EXCEL file with 100-200 candidate rows and their resumes as separate PDF files. The resume filenems are coded in a way that you can recognize which candidate each resume belongs to.
My thought was to:

  1. bulk upload the resumes file into a Folder - and this can be done
  2. bulk upload the EXCEL file into the Candidacy table  - and this can be done
  3. to run a manual task taht update each file field of records just uploaded with the path of files uploaded at step 1

For the last step I cannot see how updte the file field from the task. It is possible or I have to do something else?

UPDATE

 

I tryed to handle the file field with the REST API but I get:

{ "Code": "AlterReadOnlyData",
"Message": "Cannot perform operation because one or more fields are read-only.",
"Resource": "https://mycaspionumber.caspio.com/rest/v2/tables/my-candidacy-table/records?q.where=%22ca_codicefiscale%22%20%3D%20%27DNTGDU70R17B393E%27", "RequestId": "52A44985-0FE0-4E88-9C21-4535C17CED87" }

May be that file field cannot be modified without a datapage?

Edited by vidierre
UPDATE with some test I made
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...