Get the ID of file just streamed to SharePoint Document Folder

Question

Please read the bottom of this post, since the question has been modified.

I have been successful in taking a file off of my computer and sending it to a document library in SharePoint. However, the "Title" column in the document is blank. I would like to set the "Title" column to a certain value, but not sure how to go about it.

Here is the code I use to upload the file

    public static async Task PutFileAsync()
    {
        string genName = App.Generator;
        genName = genName.Replace(" ", "-");
        StorageLibrary videoLibrary = await StorageLibrary.GetLibraryAsync(KnownLibraryId.Videos);
        string readFolder = videoLibrary.SaveFolder.Path;
        StorageFolder videoFolder = await StorageFolder.GetFolderFromPathAsync(readFolder);
        string readFileName = App.Date + "-" + App.StartTime + "-" + App.IBX + "-" + genName + ".xlsx";
        StorageFile readFile = await videoFolder.GetFileAsync(readFileName);
        byte[] result;
        using (Stream stream = await readFile.OpenStreamForReadAsync())
        {
            using (var memoryStream = new MemoryStream())
            {
                stream.CopyTo(memoryStream);
                result = memoryStream.ToArray();
            }
        }
        var (authResult, message) = await Authentication.AquireTokenAsync();
        var httpClient = new HttpClient();
        HttpResponseMessage response;
        string posturl = MainPage.spfileurl + readFile.Name + ":/content";
        var request = new HttpRequestMessage(HttpMethod.Put, posturl);
        request.Headers.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", authResult.AccessToken);
        request.Content = new ByteArrayContent(result);
        response = await httpClient.SendAsync(request);
        var responseString = await response.Content.ReadAsStringAsync();

        await Task.Run(() =>
        {
            File.Delete(readFile.Path);
            return TaskStatus.RanToCompletion;
        });
    }

Any suggestions would be great!

Thanks!

Other information

public static string rooturl = "https://graph.microsoft.com/v1.0/sites/mycompanyinc.sharepoint.com,495435b4-60c3-49b7-8f6e-1d262a120ae5,0fad9f67-35a8-4c0b-892e-113084058c0a/";

string submiturl = rooturl + "lists/18a725ac-83ef-48fb-a5cb-950ca2378fd0/items";

public static string spfileurl = rooturl + "drive/root:/Generator_Runs/";

public static string fileurl = rooturl + "lists/edd49389-7edb-41db-80bd-c8493234eafa/drive/items/01JDP7KXPY64K4C3P4YJC2CJ2IUFG7DAP7/content";

Since it is not possible to add column data while uploading, I need to figure out what the listitem ID is for the file that I just uploaded is.

This is the responseString after the submission

[JSON]
    @odata.context: "https://graph.microsoft.com/v1.0/$metadata#sites('mycompanyinc.sharepoint.com%2C495435b4-60c3-49b7-8f6e-1d262a120ae5%2C0fad9f67-35a8-4c0b-892e-113084058c0a')/drive/root/$entity"
    @microsoft.graph.downloadUrl: "https://mycompanyinc.sharepoint.com/sites/GeneratorApp/_layouts/15/download.aspx?UniqueId=...&ApiVersion=2.0"
    createdDateTime: "12/29/2018 6:43:00 PM"
    eTag: ""{BB51689A-9FF5-412C-8B45-D01D2B61A789},2""
    id: "01JDP7KXM2NBI3X5M7FRAYWROQDUVWDJ4J"
    lastModifiedDateTime: "12/29/2018 6:43:00 PM"
    name: "FileNameJ.xlsx"
    webUrl: "https://mycompanyinc.sharepoint.com/sites/GeneratorApp/_layouts/15/Doc.aspx?sourcedoc=%7BBB51689A-9FF5-412C-8B45-D01D2B61A789%7D&file=FileName.xlsx&action=default&mobileredirect=true"
    cTag: ""c:{BB51689A-9FF5-412C-8B45-D01D2B61A789},4""
    size: 47079
    createdBy
    lastModifiedBy
    parentReference
    file
    fileSystemInfo

I don't know actual sp-url in your code. For the document, The api that used to upload the file likes [this](https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest#working-with-large-files-by-using-rest). — Nico Zhu, Dec 17 '18 at 05:48
@NicoZhu-MSFT I added the URL that gets the file to SharePoint. — CET, Dec 20 '18 at 13:24
Maybe this link useful for you:https://stackoverflow.com/questions/5337683/how-to-set-extended-file-properties — Esat ARSLAN, Dec 20 '18 at 13:30
@EsatARSLAN That seems more like Windows properties than Document Library on SharePoint. — CET, Dec 20 '18 at 13:40

score 0 · Accepted Answer · answered Dec 30 '18 at 20:30

Okay, it took a lot of trial and error. I had to create another class to be able to parse out the data:

public class SharePointDocumentNew
{
    public class RootObject
    {
        public string eTag { get; set; }
        public string id { get; set; }
        public string name { get; set; }
        public string webUrl { get; set; }
    }
}

AND

public class SharePointDocumentItems
{
    public class Value
    {
        [JsonProperty("@odata.etag")]
        public string OdataEtag { get; set; }

        public string ETag { get; set; }
        public string Id { get; set; }
        public string WebUrl { get; set; }
    }

    public class RootObject
    {
        [JsonProperty("@odata.context")]
        public string OdataContext { get; set; }

        public List<Value> value { get; set; }
    }
}

Then I found the matching data between the two and used REGEX to get the matching data with this code:

public static async Task PutFileAsync()
{
    List<SharePointListItems.Lookup> Lookups = new List<SharePointListItems.Lookup>();
    string genName = App.Generator;
    genName = genName.Replace(" ", "-");
    StorageLibrary videoLibrary = await StorageLibrary.GetLibraryAsync(KnownLibraryId.Videos);
    string readFolder = videoLibrary.SaveFolder.Path;
    StorageFolder videoFolder = await StorageFolder.GetFolderFromPathAsync(readFolder);
    string readFileName = App.Date + "-" + App.StartTime + "-" + App.IBX + "-" + genName + ".xlsx";
    StorageFile readFile = await videoFolder.GetFileAsync(readFileName);
    byte[] result;
    using (Stream stream = await readFile.OpenStreamForReadAsync())
    {
        using (var memoryStream = new MemoryStream())
        {
            stream.CopyTo(memoryStream);
            result = memoryStream.ToArray();
        }
    }
    var (authResult, message) = await Authentication.AquireTokenAsync();
    var httpClient = new HttpClient();
    HttpResponseMessage response;
    string posturl = MainPage.spfileurl + readFile.Name + ":/content";
    var request = new HttpRequestMessage(HttpMethod.Put, posturl);
    request.Headers.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", authResult.AccessToken);
    request.Content = new ByteArrayContent(result);
    response = await httpClient.SendAsync(request);
    var responseString = await response.Content.ReadAsStringAsync();
    JObject json = JObject.Parse(responseString);
    var result3 = JsonConvert.DeserializeObject<SharePointDocumentNew.RootObject>(responseString);
    eTag = result3.eTag.ToString();
    eTag = eTag.Replace("\"{", "");
    string replacement = "";
    string endPattern = "}.*";
    Regex rgxend = new Regex(endPattern);
    eTag = rgxend.Replace(eTag, replacement);
    eTag = Regex.Replace(eTag, @"[A-Z]+?", m => m.ToString().ToLower());

    await Task.Run(() =>
    {
        File.Delete(readFile.Path);
        return TaskStatus.RanToCompletion;
    });
}

public static async Task GetFileDataAsync()
{
    List<SharePointDocumentItems.Value> Value2 = new List<SharePointDocumentItems.Value>();
    var (authResult2, message2) = await Authentication.AquireTokenAsync();
    var httpClient2 = new HttpClient();
    HttpResponseMessage response2;
    string geturl = "https://graph.microsoft.com/v1.0/sites/mycoinc.sharepoint.com,495435b4-60c3-49b7-8f6e-1d262a120ae5,0fad9f67-35a8-4c0b-892e-113084058c0a/lists/edd49389-7edb-41db-80bd-c8493234eafa/items";
    var request2 = new HttpRequestMessage(HttpMethod.Get, geturl);
    request2.Headers.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", authResult2.AccessToken);
    response2 = await httpClient2.SendAsync(request2);
    var responseString2 = await response2.Content.ReadAsStringAsync();
    JObject json2 = JObject.Parse(responseString2);
    var result2 = JsonConvert.DeserializeObject<SharePointDocumentItems.RootObject>(responseString2);
    foreach (var d in result2.value)
    {
        string ETAG = d.ETag;
        string startPattern = "^\\\"";
        string replacement = "";
        string endPattern = ",.*";
        Regex rgxstart = new Regex(startPattern);
        ETAG = rgxstart.Replace(ETAG, replacement);
        Regex rgxend = new Regex(endPattern);
        ETAG = rgxend.Replace(ETAG, replacement);
        if (ETAG == eTag)
        {
            fileID = d.Id;
        }
    }
}

Now I have the ID I need to update the other columns associated with the file.

Get the ID of file just streamed to SharePoint Document Folder

Please read the bottom of this post, since the question has been modified.

1 Answers1