Unanswered

Update file metadata via Rest api Sharepoint

(0) Share

Report

Posted on by rolanddaane

Hi,
I'm trying to update a files metadata by using the Sharepoint Rest API.

Now I'm getting this error: Input string was not in a correct format.

Are there examples how to do this?
I'm struggeling with the Json body code I think.

First I get the file info by calling /_api/Web/Lists/getByTitle('Archived')/Items('31')

Then I parse the output to Json and create the variables (project, originator, volume, level, type,rol)
Then I post to the api endpoint.

My Flow can be found here: https://app.box.com/s/dmw1ykn9j6h44uy89a7duxzrk9okp6m9

Any help is much apreciated

Categories:

General topics

All responses (4)

Answers (0)

Sort by

mahoneypat 1,720 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you already looked at the Peek Code for that step to see if something is off? For example, is the / in front of the URI needed, or do you see two of them in Peek Code? Or do you need to convert var_GUID to text?

Pat
rolanddaane 73 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
There seems to an issue with the input because I get the error "Input string was not in a correct format".
I hardcoded the site address, and then the URI has to start with a "/".
This is the input code from the call:

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "HttpRequest"
    },
    "parameters": {
        "dataset": "https://bamgroup.sharepoint.com/sites/025556",
        "parameters/method": "POST",
        "parameters/uri": "/_api/Web/Lists/getByTitle('Archived')/Items('a7bda960-be35-45fa-bd0e-d9169749a715')",
        "parameters/headers": {
            "content-type": "application/json;odata=verbose",
            "accept": "application/json;odata=verbose",
            "X-HTTP-Method": "MERGE",
            "If-Match": "*"
        },
        "parameters/body": "{\n  \"__metadata\": {\n    \"type\": \"SP.Data.ArchivedListItem\"\n  },\n  \"Title\": \"NewTitle\"\n}"
    }
}
rolanddaane 73 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah I did, but I also parsed the output to Json, and viewed that output.
In the xml scheme I saw that the column had a different name.....

What do you mean with Peek Code?
Thanks!
Schwerzmann 40 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rolanddaane
The seems to be a while ago, but might still be a topic?
I had a similar situation while trying to update a file content type in SharePoint via RestAPI. I struggled over and over even I was seeing no error in my syntax at all. Finally, I was able to solve it by first composing a JSON with the following structure (this is valid for Content Type changes only):
{ "{ContentType}": { "@@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType", "Id": "[0x010100_______]", "Name": "[DocumentContentTypeName]" } }
The output of this step I loaded into my Body-Part of the "HTTP request to SharePoint"-step and it suddenly worked.
So, you might try to load your body part into a "Compose JSON" step first and reuse that one instead.
Good luck 😉