Add metadata(columns data) to a file in Document Library using java. Sharepoint 2013

Question

I'm new to sharepoint, I've created a web services where i post files to a document library but i also want to add metadata(columns data) 'Title' at the same time as i post the file using java. Is there any URL endpoint build in sharepoint i can use to accomplish this task?

Answer 1

You have not specified what web services you are using. You should keep in mind that SOAP web services are deprecated for SharePoint 2013. REST web services are most common for SharePoint 2013 and I hope you are using them.

Answering your question, there in no way to upload document and set metadata in one request. You have to do this in 3 steps:

1. Upload document using FileCollectionAdd Endpoint. You can reference to specific location by:
   List Title POST http://<sitecollection>/<site>/_api/web/lists(listid)/rootFolder
   List ID POST http://<sitecollection>/<site>/_api/web/lists/getByTitle(title)
   Folder URL "http://<sitecollection>/<site>/_api/web /getfolderbyserverrelativeurl(<url>)/files /add(overwrite=true,url='filename.txt')
   You will get uploaded SP.File in your response.
2. You have to get SP.ListItem associated with your new SP.File using GET http://<sitecollection>/<site>/_api/web/folders/getbyurl(folderrelativeurl)/files/getbyurl(filerelativeurl)/listItemAllFields endpoint.
   You will get SP.ListItem in your response.
3. You can update SP.ListItem information for your SP.ListItem using POST http://<sitecollection>/<site>/_api/web/lists(listid)/getItemById(id) endpoint https://msdn.microsoft.com/EN-US/library/office/dn292552.aspx#ListItems

At first is looks quite complicated, but it works well. I can not find examples on Java, but where are some examples using javascript, so the steps are the same:

• How to: Upload a file by using the REST API and jQuery
• Properties when uploading Files using REST in SP 2013

Or you can view the documentation Working with folders and files with REST

Answer 2

This is how i make a POST to document library right now.. The next step is to make a GET to that file in document library but i can't figure it out. Sorry if this is bothersome but i'm new to this. How should the url look like for the GET?

documentLibrary = sharepoint server url to document library
http://industrial-ex/sites/tifdemo/enovia/

enoviaDocument = local path to a file
D:\tif-destination

if (enoviaDocument.isFile()) { FileInputStream fileInputStream = new FileInputStream(enoviaDocument); PutMethod method = new PutMethod(documentLibrary + enoviaDocument.getName()); RequestEntity requestEntity = new InputStreamRequestEntity(fileInputStream); method.setRequestEntity(requestEntity); Constant.getHttpclient().executeMethod(method);

                System.out.println("STATUS CODE: " + method.getStatusCode() + " " + "STATUS TEXT: "
                        + method.getStatusText());



            }

Answer 3

@ECM4D

This url works: http://industrial-ex/sites/tifdemo/_api/lists/getbytitle('enovia')/items

I can see my document file but how do i then select the metadata?

This is the Java Code: String url = "http://industrial-ex/sites/tifdemo/_api/lists/getbytitle('enovia')/items"; GetMethod get = new GetMethod(url); authentication.getHttpClient().executeMethod(get); System.out.println("RESPONSE BODY: " + get.getResponseBody());