topic RE: BOX API Upload in Product Forum

BOX API Upload

matthew.cable — Thu, 02 Feb 2023 14:44:00 GMT

Hi

Please can I have some assistance with regards to uploading a document to Box via an API.

Currently our API's go through Mulesoft, I have managed to create API's in Blue Prism to Search, Delete Folder, Delete File, Get folders etc... However I can get the Document Upload request to work.
This is working in Postman, but I am unsure how to move this into Blue Prism. We are using Basic Access which works fine.

I have done all of it so far via Web API Services and would like to keep the upload in that part also

I have attached a file with what postman looks like and from BOX what they require.

Thank you

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Thu, 02 Feb 2023 20:09:00 GMT

Hello @Matthew Coleman,

From the looks of it, you need to perform a multipart form upload of the document with some JSON added to the body. You can do that with the Web API Services feature, but it will require you to use the Template option for the body content. You will then need to define the body template. There are a few discussions on the community about this sort of thing. I've linked one below.

https://community.blueprism.com/discussion/error-while-upload-a-file-with-api-using-multipart-form-data#bm79e4317e-9b6e-4bac-a806-f84963a5c657

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Fri, 03 Feb 2023 08:14:00 GMT

Hi @ewilson

Thank you very much for the quick response, I have attempted what the others ones mentioned but this has not worked.

I am getting a 415 error, i have tried with and without a binary file.

Please can you assist further, I have added screenshots below of the API

Thank you
Matt

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Fri, 03 Feb 2023 16:39:00 GMT

@Matthew Cable,

I would try something like this:

--[boundary]
Content-Type: application/json; charset=UTF-8

{
  "name": "[fileName]",
  "parent": {
    "id": "[id]"
  }
}

--[boundary]
Content-Disposition: form-data; name="[fileName]"
Content-Type: [mimeType]
Content-Transfer-Encoding: base64

[fileValue]
--[boundary]--

When performing a multi-part your binary file contents should be at the end of the request followed by only a --[YOUR BOUNDRY]--. Also, the Content-Type header should be set to whatever the mime type of the file is. For example, if it's a PDF you should set the Content-Type to application/pdf.

Parameters Above:

boundary
- Type: Text
- Ex Value: ----------xyz
fileName
- Type: Text
- Ex Value: MattTestFile2.txt
mimeType
- Type: Text
- Ex Value: text/plain
fileValue
- Type: Binary
- Ex Value: Binary contents of a file.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Mon, 06 Feb 2023 09:03:00 GMT

Hi @ewilson,

Thank you for the above, I am still receiving a 415 error message.

Below is how I have entered it.

My parameters have been

fileName = "MattTestFile2.txt"
Folderid = "Example 123456"
mimeType = "text/plain"
Binary = Example, the binary path.

Below is the error.

Any more help you can provide would be greatly appreciated.

Thank you

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Mon, 06 Feb 2023 13:58:00 GMT

@Matthew Cable,

My recommendation would be to test this from Postman one more time, but after you do take a look at the raw message in the Postman Console to see exactly how Postman set it up. It should include all the header and form information. Then it's just a matter of recreating that in the Web API definition.

Here's an example:
You might have to click on the Show raw log option in the top right corner of the Console display.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Tue, 14 Feb 2023 10:56:00 GMT

Hi @ewilson

Thank you for the assistance, we are still struggling at this side to work it.
Are there any other suggestions? we are getting a 400 error.

Postman it works fine but duplicating in Blue Prism is still an issue.

Thank you

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Tue, 14 Feb 2023 14:50:00 GMT

Hi @Matthew Cable

Can you share screenshots of the Postman raw log information and your current template definition?
What are you setting the Content-Type value to?
Are you passing in a binary file? If so, have you tried setting Content-Type to application/octet-stream?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Wed, 15 Feb 2023 14:03:00 GMT

Hi @ewilson

Below is screen shot from Postman raw data being input

Below is what I am using, on difference is the ID folder location i am saving to, I decided to just hardcode most of it for now into the template until i can find out what is wrong.

Below is the error message I am seeing

Here is a link to the BOX developer portal on how to upload a document

https://developer.box.com/reference/post-files-content/

I have amended the content type but i now get a 415 error

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Wed, 15 Feb 2023 15:00:00 GMT

@Matthew Cable

One quick question. The lines I highlighted below are actually on one single line within your template definition, correct? So the actual Content-Disposition entry looks like this: Content-Disposition: form-data; name="attributes"; Just making sure because you do not want these particular items to have line breaks.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Wed, 15 Feb 2023 15:34:00 GMT

@Brett Erickson

Yes one line.

On the box site it looks like this, we do not use Bearer accesses tokens though

curl -i -X POST "https://upload.box.com/api/2.0/files/content" \
-H "Authorization: Bearer <ACCESS_TOKEN>" \
-H "Content-Type: multipart/form-data" \
-F attributes='{"name":"Contract.pdf", "parent":{"id":"11446498"}}' \
-F file=@<FILE_NAME>

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Wed, 15 Feb 2023 17:11:00 GMT

@Matthew Cable

Have you looked at the Box API connector that's available on the Digital Exchange? I've run some tests with the Upload File action in it and it works fine. This is a VBO as opposed to a Web API though. Not sure if that bothers you. If you want to give it a try you'll want to make sure you also have the latest version of the Utility - HTTP VBO installed too.

https://digitalexchange.blueprism.com/dx/entry/9648/solution/box-api

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Thu, 16 Feb 2023 07:41:00 GMT

@ewilson

I have downloaded it, but it has compile errors, so does the latest Utilities JSON to collection.
I have attempted in the HTTP but still get issues.

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

ewilson — Thu, 16 Feb 2023 14:48:00 GMT

@Matthew Cable

The HTTP VBO and the JSON VBO should both have a version number listed on the Initialise tab. Can you post screenshots of those?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: BOX API Upload

matthew.cable — Fri, 17 Feb 2023 08:17:00 GMT

Hi @ewilson

The first is the Json to collection

The next is HTTP

Thank you

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

GeoffHirst — Fri, 17 Feb 2023 13:42:00 GMT

Matthew,

Thank you for being a SS&C Customer and for using SS&C Blue Prism.

In connection with the JSON asset, could I ask you download it again from the DX? The reason being I have been adding functionality to it this week and to be honest your error looks like C# code is being validated by a VB.NET parser. I could be wrong, but that's what it looks like.

The current version, which I posted yesterday, is V10.0.1 and has 2 new actions for working with JsonPath. This might resolve at least some of your issues. With regards the issues shown for the HTTP VBO would require a little investigation, could you advise the version of Blue Prism you are using?

Let me know how you get on and if we can help any further.

Once again, thank you for using SS&C Blue Prism.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: BOX API Upload

matthew.cable — Mon, 20 Feb 2023 08:34:00 GMT

hi @Geoff Hirst

I have downloaded the latest version and still have a handful of errors below. We are also using V6.7.2

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

GeoffHirst — Mon, 20 Feb 2023 08:52:00 GMT

Hi Matthew,

Could you take a look at the initialise page of the Json asset. Does yours look like this?

The areas in yellow are the important bits to determine if you have the most current version (you may not have, I only posted it back to the DX last week and it may not have made it through QA).

If we can determine that then at least that will explain that. If I look at the error list on my machine for this asset it doesn't show any. So we need to see what is causing this issue for you. There is a national holiday in the US today, so I will assist you as much as I can.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------

RE: BOX API Upload

matthew.cable — Mon, 20 Feb 2023 10:35:00 GMT

@GeoffHirst

Please see screen shot below, looks like the latest one.

------------------------------
Matthew Cable
Consultant
Zurich
Europe/London
------------------------------

RE: BOX API Upload

GeoffHirst — Mon, 20 Feb 2023 11:49:00 GMT

Hi Matthew,

That screen of dependencies actually hasn't changed, I was just interested to see that your version was set to C# which it is. What we need to look at is the version number on the initialize page. If you have the latest, then its 10.0.1.

Can you also provide that list of errors as a full window, so that we can see which asset is actually causing the problem as right now I can't replicate what you are seeing but we will get to the bottom of the problem.

regards

------------------------------
Geoff Hirst
Senior DX Engineer - Digital Exchange - EMEA
SS&C Blue Prism
------------------------------