1. map SaveUploadToVectorStore(string report_link_name, string record_id, string filename, string vector_store_id)
2. {
3. // Download a file from current app
4. download_url = "https://creator.zoho.eu/api/v2" + zoho.appuri + "report/" + report_link_name + "/" + record_id + "/File_upload/download";
5. 
   
6. downloaded_file = invokeurl
7. [
8. url :download_url
9. type :GET
10. connection:"zohocreator"
11. ];
12. 
    
13. // Ensure correct filename
14. downloaded_file.setFileName(filename);
15. 
    
16. // Upload to OpenAI
17. multipart_parts = List();
18. multipart_parts.add({"paramName":"purpose","content":"assistants","stringPart":"true"});
19. multipart_parts.add({"paramName":"file","content":downloaded_file});
20. 
    
21. upload_resp = invokeurl
22. [
23. url :"https://api.openai.com/v1/files"
24. type :POST
25. connection:"openai_connection"
26. files:multipart_parts
27. ];
28. 
    
29. file_id = "";
30. if(upload_resp != null && upload_resp.containKey("id"))
31. {
32. file_id = upload_resp.get("id");
33. }
34. 
    
35. // Attach to vector store
36. if(file_id != "")
37. {
38. attach_headers = Map();
39. attach_headers.put("Content-Type","application/json");
40. attach_headers.put("OpenAI-Beta","assistants=v2");
41. 
    
42. attach_body = Map();
43. attach_body.put("file_id", file_id);
44. 
    
45. invokeurl
46. [
47. url :"https://api.openai.com/v1/vector_stores/" + vector_store_id + "/files"
48. type :POST
49. connection:"openai_connection"
50. headers:attach_headers
51. parameters:attach_body.toString()
52. ];
53. }
54. 
    
55. result = Map();
56. result.put("file_id", file_id);
57. 
    
58. return result;
59. }

Key prerequisites

For this to work, you need:

1. A Zoho Creator OAuth connection

   • Must have permission to download files from your app.

   • Used in the invokeurl download call.

   • Example link name: "zohocreator"

2. An OpenAI API Key connection

   • Connection type: API Key

   • Header:
     Authorization = Bearer <your_openai_key>

   • Example link name: "openai_connection"

3. Correct region

   • Adjust creator.zoho.eu if you are using .com, .in, etc.

4. Correct report link name

   • The report must expose the File Upload field.

5. Use actualname
   Zoho prepends a unique ID to uploaded files.
   Use:

   filename = input.File_upload.actualname;
   

   This removes the internal prefix and ensures the correct file extension (e.g. .pdf) is preserved.
   Without this, OpenAI may receive the file as "content" and reject it with File type not supported.