Visual FoxPro Requires Chilkat v11.7.0+
Visual FoxPro
Box: Create a Project Folder, Upload, Tag, and Link a Document
See more Box Examples
Run the reusable setup once per HttpCurl object, then select names and execute the operation. The setup is repeated here only to make this published example independently runnable. Resolve the parent documents folder by name, create a new project folder, upload a document, apply pre-existing projectDocument metadata, and create a collaborators-only link. Creation outputs remain cached for subsequent operations; the engine resolves the enterprise scope only when metadata needs it. Multipart formatting and deliberate writes remain explicit.
See the Box API guide for setup and the complete workflow.
Chilkat Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loCurl
LOCAL loSetupCommand
LOCAL lnSetupReplacements
LOCAL lcParentName
LOCAL loAuthorizedCommand1
LOCAL lnHeaderReplacement1
LOCAL loUploadCommand
LOCAL loAuthorizedCommand2
LOCAL lnHeaderReplacement2
LOCAL lnReplacements
LOCAL loAuthorizedCommand3
LOCAL lnHeaderReplacement3
LOCAL loAuthorizedCommand4
LOCAL lnHeaderReplacement4
lnSuccess = 0
* Requires Chilkat 11.7.0 or later and a previously unlocked Chilkat bundle.
* See Global Unlock Sample.
* Guide: Box API Guide.
lnSuccess = 0
* BEGIN ONE-TIME SETUP
* This block is repeated so each published example can run on its own.
* In an application, run the setup example once and pass the SAME curl object
* to operation code below. Do not recreate it for every operation.
* See Reusable Box HttpCurl Setup.
loCurl = CreateObject('Chilkat.HttpCurl')
loCurl.SetVar("access_token","BOX_ACCESS_TOKEN")
loCurl.SetVar("parent_name","/")
* Box's fixed root ID is an implementation detail; callers supply names.
loCurl.SetVar("parent_id","0")
loSetupCommand = CreateObject('Chilkat.StringBuilder')
* Register findParent; registration sends no request.
loSetupCommand.SetString('curl -X GET "https://api.box.com/2.0/folders/0/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"')
lnSetupReplacements = loSetupCommand.Replace("ACCESS_TOKEN",loCurl.GetVar("access_token"))
lnSuccess = loCurl.AddFunction("findParent",loSetupCommand.GetAsString())
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* Register findFolder; registration sends no request.
loSetupCommand.SetString('curl -X GET "https://api.box.com/2.0/folders/{{parent_id}}/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"')
lnSetupReplacements = loSetupCommand.Replace("ACCESS_TOKEN",loCurl.GetVar("access_token"))
lnSuccess = loCurl.AddFunction("findFolder",loSetupCommand.GetAsString())
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* Register findFile; registration sends no request.
loSetupCommand.SetString('curl -X GET "https://api.box.com/2.0/folders/{{folder_id}}/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"')
lnSetupReplacements = loSetupCommand.Replace("ACCESS_TOKEN",loCurl.GetVar("access_token"))
lnSuccess = loCurl.AddFunction("findFile",loSetupCommand.GetAsString())
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* Register findDestination; registration sends no request.
loSetupCommand.SetString('curl -X GET "https://api.box.com/2.0/folders/0/items?limit=1000&fields=id,type,name" -H "Authorization: Bearer ACCESS_TOKEN"')
lnSetupReplacements = loSetupCommand.Replace("ACCESS_TOKEN",loCurl.GetVar("access_token"))
lnSuccess = loCurl.AddFunction("findDestination",loSetupCommand.GetAsString())
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* Register getFileDetails; registration sends no request.
loSetupCommand.SetString('curl -X GET "https://api.box.com/2.0/files/{{file_id}}?fields=id,sha1,file_version" -H "Authorization: Bearer ACCESS_TOKEN"')
lnSetupReplacements = loSetupCommand.Replace("ACCESS_TOKEN",loCurl.GetVar("access_token"))
lnSuccess = loCurl.AddFunction("getFileDetails",loSetupCommand.GetAsString())
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* Register getEnterprise; registration sends no request.
loSetupCommand.SetString('curl -X GET "https://api.box.com/2.0/users/me?fields=enterprise" -H "Authorization: Bearer ACCESS_TOKEN"')
lnSetupReplacements = loSetupCommand.Replace("ACCESS_TOKEN",loCurl.GetVar("access_token"))
lnSuccess = loCurl.AddFunction("getEnterprise",loSetupCommand.GetAsString())
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* Register output rules once. Chilkat 11.7.0 evaluates {{name}} variables
* when extracting each output, using the current value at that time.
lnSuccess = loCurl.AddOutput2("findParent","entries","name","{{parent_name}}",1,"id","parent_id")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
lnSuccess = loCurl.AddOutput2("findFolder","entries","name","{{folder_name}}",1,"id","folder_id")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
lnSuccess = loCurl.AddOutput2("findFile","entries","name","{{file_name}}",1,"id","file_id")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
lnSuccess = loCurl.AddOutput2("findDestination","entries","name","{{destination_name}}",1,"id","destination_id")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
lnSuccess = loCurl.AddOutput("getFileDetails","file_version.id","file_version_id")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
lnSuccess = loCurl.AddOutput("getFileDetails","sha1","file_sha1")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
lnSuccess = loCurl.AddOutput("getEnterprise","enterprise.id","enterprise_id")
IF (lnSuccess <> 1) THEN
? loCurl.LastErrorText
RELEASE loCurl
RELEASE loSetupCommand
CANCEL
ENDIF
* END ONE-TIME SETUP
* The name lookups below assume each listing fits in one page (1000 items).
* Parent and destination names select root children; folder_name selects a child
* of parent_name. "/" selects the root parent. These are not arbitrary paths.
* BEGIN OPERATION -- keep the configured object when reusing it.
* Inputs are names. Retain cached IDs when the selected names have not changed.
lcParentName = "documents"
IF ((loCurl.GetVar("parent_name") <> lcParentName) OR ((lcParentName = "/") AND (loCurl.VarDefined("parent_id") = 0))) THEN
loCurl.SetVar("parent_name",lcParentName)
loCurl.ClearVar("parent_id")
loCurl.ClearVar("folder_id")
loCurl.ClearVar("file_id")
loCurl.ClearVar("file_version_id")
loCurl.ClearVar("file_sha1")
IF (lcParentName = "/") THEN
loCurl.SetVar("parent_id","0")
ENDIF
ENDIF
loCurl.SetVar("new_folder_name","Project CUST-1001")
* This workflow creates a new folder. A 409 stops the example; it does not
* silently reuse a same-named folder. Retain printed IDs if a later step fails.
loCurl.ClearTargetOutput("*")
loCurl.ClearVar("folder_id")
loCurl.AddTargetOutput("id","folder_id")
loAuthorizedCommand1 = CreateObject('Chilkat.StringBuilder')
loAuthorizedCommand1.SetString('curl -X POST "https://api.box.com/2.0/folders" -H "Authorization: Bearer {{access_token}}" -H "Content-Type: application/json" -d '{"name":"{{new_folder_name}}","parent":{"id":"{{parent_id}}"}}'')
lnHeaderReplacement1 = loAuthorizedCommand1.Replace("{{access_token}}",loCurl.GetVar("access_token"))
lnSuccess = loCurl.DoYourThing(loAuthorizedCommand1.GetAsString())
IF ((lnSuccess <> 1) OR (loCurl.StatusCode <> 201)) THEN
? "Box request failed. HTTP status: " + STR(loCurl.StatusCode)
? "Failure reason: " + STR(loCurl.FailReason)
? loCurl.ResponseBodyStr
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
CANCEL
ENDIF
IF (loCurl.VarDefined("!") <> 1) THEN
? "Expected response fields are missing."
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
CANCEL
ENDIF
? "Created folder: " + loCurl.GetVar("folder_id")
* Resolve the multipart attributes field before passing the command to HttpCurl.
* Box folder IDs come from configuration or a previous API response.
loUploadCommand = CreateObject('Chilkat.StringBuilder')
loAuthorizedCommand2 = CreateObject('Chilkat.StringBuilder')
loAuthorizedCommand2.SetString('curl -X POST "https://upload.box.com/api/2.0/files/content" -H "Authorization: Bearer {{access_token}}" -F 'attributes={"name":"invoice.pdf","parent":{"id":"{{folder_id}}"}}' -F "file=@qa_data/pdf/invoice.pdf;type=application/pdf"')
lnHeaderReplacement2 = loAuthorizedCommand2.Replace("{{access_token}}",loCurl.GetVar("access_token"))
loUploadCommand.SetString(loAuthorizedCommand2.GetAsString())
lnReplacements = loUploadCommand.Replace("{{folder_id}}",loCurl.GetVar("folder_id"))
loCurl.ClearTargetOutput("*")
loCurl.ClearVar("file_id")
loCurl.AddTargetOutput("entries[0].id","file_id")
lnSuccess = loCurl.DoYourThing(loUploadCommand.GetAsString())
IF ((lnSuccess <> 1) OR (loCurl.StatusCode <> 201)) THEN
? "Box request failed. HTTP status: " + STR(loCurl.StatusCode)
? "Failure reason: " + STR(loCurl.FailReason)
? loCurl.ResponseBodyStr
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
RELEASE loUploadCommand
RELEASE loAuthorizedCommand2
CANCEL
ENDIF
IF (loCurl.VarDefined("!") <> 1) THEN
? "Expected response fields are missing."
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
RELEASE loUploadCommand
RELEASE loAuthorizedCommand2
CANCEL
ENDIF
? "Uploaded file: " + loCurl.GetVar("file_id")
loCurl.ClearTargetOutput("*")
loAuthorizedCommand3 = CreateObject('Chilkat.StringBuilder')
loAuthorizedCommand3.SetString('curl -X POST "https://api.box.com/2.0/files/{{file_id}}/metadata/enterprise_{{enterprise_id}}/projectDocument" -H "Authorization: Bearer {{access_token}}" -H "Content-Type: application/json" -d '{"customerId":"CUST-1001","status":"received"}'')
lnHeaderReplacement3 = loAuthorizedCommand3.Replace("{{access_token}}",loCurl.GetVar("access_token"))
lnSuccess = loCurl.DoYourThing(loAuthorizedCommand3.GetAsString())
IF ((lnSuccess <> 1) OR (loCurl.StatusCode <> 201)) THEN
? "Box request failed. HTTP status: " + STR(loCurl.StatusCode)
? "Failure reason: " + STR(loCurl.FailReason)
? loCurl.ResponseBodyStr
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
RELEASE loUploadCommand
RELEASE loAuthorizedCommand2
RELEASE loAuthorizedCommand3
CANCEL
ENDIF
loCurl.ClearTargetOutput("*")
loCurl.ClearVar("shared_url")
loCurl.AddTargetOutput("shared_link.url","shared_url")
loAuthorizedCommand4 = CreateObject('Chilkat.StringBuilder')
loAuthorizedCommand4.SetString('curl -X PUT "https://api.box.com/2.0/files/{{file_id}}?fields=id,shared_link" -H "Authorization: Bearer {{access_token}}" -H "Content-Type: application/json" -d '{"shared_link":{"access":"collaborators"}}'')
lnHeaderReplacement4 = loAuthorizedCommand4.Replace("{{access_token}}",loCurl.GetVar("access_token"))
lnSuccess = loCurl.DoYourThing(loAuthorizedCommand4.GetAsString())
IF ((lnSuccess <> 1) OR (loCurl.StatusCode <> 200)) THEN
? "Box request failed. HTTP status: " + STR(loCurl.StatusCode)
? "Failure reason: " + STR(loCurl.FailReason)
? loCurl.ResponseBodyStr
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
RELEASE loUploadCommand
RELEASE loAuthorizedCommand2
RELEASE loAuthorizedCommand3
RELEASE loAuthorizedCommand4
CANCEL
ENDIF
IF (loCurl.VarDefined("!") <> 1) THEN
? "Expected response fields are missing."
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
RELEASE loUploadCommand
RELEASE loAuthorizedCommand2
RELEASE loAuthorizedCommand3
RELEASE loAuthorizedCommand4
CANCEL
ENDIF
? "Document link: " + loCurl.GetVar("shared_url")
* The link is for existing collaborators. Invite users separately when needed.
* ClearTargetOutput removes old extraction rules; it does not clear existing IDs.
loCurl.SetVar("folder_name",loCurl.GetVar("new_folder_name"))
loCurl.SetVar("file_name","invoice.pdf")
loCurl.ClearVar("file_version_id")
loCurl.ClearVar("file_sha1")
RELEASE loCurl
RELEASE loSetupCommand
RELEASE loAuthorizedCommand1
RELEASE loUploadCommand
RELEASE loAuthorizedCommand2
RELEASE loAuthorizedCommand3
RELEASE loAuthorizedCommand4