{"id":148592,"date":"2023-07-27T16:50:27","date_gmt":"2023-07-27T07:50:27","guid":{"rendered":"https:\/\/support.questetra.com\/?p=148592"},"modified":"2023-07-31T15:14:14","modified_gmt":"2023-07-31T06:14:14","slug":"openai-files-list-2023","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/openai-files-list-2023\/","title":{"rendered":"OpenAI #Files: List"},"content":{"rendered":"\n

OpenAI #Files: List<\/strong><\/h4>\n\n\n\n

translate<\/span> OpenAI #Files: \u30ea\u30b9\u30c8<\/a><\/p>\n\n\n\n

Lists the files on the OpenAI API server. For all files belonging to the user organisation, the four attributes File ID, Purpose, File Size and File Name are stored as TSV text.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
AuthzConfU1<\/dt>
U1: Select HTTP_Authz Setting (Secret API Key as “Fixed Value”) *<\/span><\/dd>\n
SelectConfA1<\/dt>
A1: Select STRING that stores TSV (update) *<\/span><\/dd>\n<\/div>\n
StrConfU2<\/dt>
U2: Set OpenAI Organization ID (“org-xxxx”)#{EL}<\/sup><\/span><\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ GraalJS standard mode Script Script (engine type: 3)\n\/\/ cf. 'engine type: 2': "GraalJS Nashorn compatible mode" (renamed from "GraalJS" at 20230526)\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting     = configs.get( "AuthzConfU1" );             \/\/\/ REQUIRED\n  engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strOrgId            = configs.get( "StrConfU2" );               \/\/ NotRequired\n  engine.log( " AutomatedTask Config: OpenAI-Organization: " + strOrgId );\nconst strPocketTsv        = configs.getObject( "SelectConfA1" );      \/\/\/ REQUIRED\n\n\n\/\/\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\n\/\/\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/\/ OpenAI API > Documentation > API REFERENCE > FILES > List files\n\/\/\/\/ https:\/\/platform.openai.com\/docs\/api-reference\/files\/list\n\n\/\/\/ prepare request1\nlet request1Uri = "https:\/\/api.openai.com\/v1\/files";\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n    if ( strOrgId !== "" ){\n      request1 = request1.header( "OpenAI-Organization", strOrgId );\n    }\n\n\/\/\/ try request1\nconst response1     = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + ""; \/\/ JavaNum to string\nconst response1Body = response1.getResponseAsString();\nengine.log( " AutomatedTask ApiResponse1 Status: " + response1Code );\nif( response1Code !== "200"){\n  throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n                    response1Code + "\\n" + response1Body + "\\n" );\n}\n\/* engine.log( response1Body ); \/\/ debug\n{\n  "object": "list",\n  "data": [\n    {\n      "object": "file",\n      "id": "file-rM8tP15b9pZ2tJSLZEfUl7fG",\n      "purpose": "fine-tune",\n      "filename": "training-data-questetra-bpm-suite-assistant.jsonl",\n      "bytes": 6823,\n      "created_at": 1690249576,\n      "status": "processed",\n      "status_details": null\n    },\n    {\n      "object": "file",\n      "id": "file-P6mdMBuR56sxgco3pr9qHAVm",\n      "purpose": "fine-tune",\n      "filename": "training-data-questetra-bpm-suite-assistant.jsonl",\n      "bytes": 6823,\n      "created_at": 1690252892,\n      "status": "processed",\n      "status_details": null\n    }\n  ]\n}*\/\n\n\/\/\/ parse response1\nconst response1Obj = JSON.parse( response1Body );\nengine.log( " AutomatedTask OpenAI #listed " );\n\nlet arrData = [];\nfor ( let i = 0; i < response1Obj.data.length; i++ ) {\n  arrData.push ( \n    response1Obj.data[i].id      + '\\t' +\n    response1Obj.data[i].purpose + '\\t' +\n    response1Obj.data[i].bytes   + '\\t' +\n    response1Obj.data[i].filename\n  );\n}\n\n\n\/\/\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketTsv !== null ){\n  engine.setData( strPocketTsv, arrData.join('\\n') );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/*\nNotes:\n- If you place this "Automated Step" in the Workflow diagram, the request will be automatically sent every time the process token arrives.\n    - A request is automatically sent to the OpenAI API server. (REST API)\n    - The response from the OpenAI API server is automatically parsed.\n- This "Automated Step" will list all files on the OpenAI server.\n    - All files belonging to the organization are listed.\n\nAPPENDIX\n- To activate a Workflow App that includes this Automated Step, "HTTP Authz Setting" is required\n    - Obtain a "Secret API Key" in advance.\n    - Set the key as the communication token in "Token Fixed Value"\n\n\nNotes-ja:\n- \u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u3092\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u56f3\u306b\u914d\u7f6e\u3059\u308c\u3070\u3001\u6848\u4ef6\u304c\u5230\u9054\u3059\u308b\u5ea6\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u81ea\u52d5\u9001\u4fe1\u3055\u308c\u307e\u3059\u3002\n    - OpenAI API \u30b5\u30fc\u30d0\u306b\u5bfe\u3057\u3066\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u81ea\u52d5\u9001\u51fa\u3055\u308c\u307e\u3059\u3002\uff08REST API\u901a\u4fe1\uff09\n    - OpenAI API \u30b5\u30fc\u30d0\u304b\u3089\u306e\u30ec\u30b9\u30dd\u30f3\u30b9\u304c\u81ea\u52d5\u4fdd\u5b58\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\n- \u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306f\u3001OpenAI \u30b5\u30fc\u30d0\u4e0a\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7\u3057\u307e\u3059\u3002\n    - \u7d44\u7e54\u306b\u5e30\u5c5e\u3059\u308b\u5168\u3066\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u4e00\u89a7\u3055\u308c\u307e\u3059\u3002\n\nAPPENDIX-ja\n- \u3053\u306e\uff3b\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\uff3d\u3092\u542b\u3080\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u3092\u904b\u7528\u3059\u308b\u306b\u306f\uff3bHTTP \u8a8d\u8a3c\u8a2d\u5b9a\uff3d\u304c\u5fc5\u8981\u3067\u3059\u3002\n    - \u3042\u3089\u304b\u3058\u3081 "Secret API Key" \u3092\u53d6\u5f97\u3057\u3066\u304a\u3044\u3066\u304f\u3060\u3055\u3044\u3002\n    - "Secret API Key" \u3092\u901a\u4fe1\u30c8\u30fc\u30af\u30f3\u3068\u3057\u3066\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\uff3b\u30c8\u30fc\u30af\u30f3\u76f4\u63a5\u6307\u5b9a\uff3d\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n