Error 400 when using Google API Explorer

Question

I'm getting the following error when using the Google API Explorer to insert into GCP's Datastore.

I've tried using another name and ID, but still the error. How do I rectify this?

Below are the request body and error.

{
    "mode": "Transactional",
    "mutations": [
        {
            "insert": {
                "key": {
                    "path": [
                        {
                            "id": "56294995342131231",
                            "name": "CL-001",
                            "kind": "Log"
                        }
                    ],
                    "partitionId": {
                        "namespaceId": "",
                        "projectId": "triplog-169706"
                    }
                },
                "properties": {
                    "Title": {
                        "stringValue": "Space Needle"
                    },
                    "Longitude": {
                        "doubleValue": 0.00
                    },
                    "Latitude": {
                        "doubleValue": 0.00
                    },
                    "Date": {
                        "timestampValue": "2015-07-03T10:51:50.649Z"
                    },
                    "Rating": {
                        "integerValue": "5"
                    },
                    "Notes": {
                        "stringValue": "Wonderful site to see"
                    }
                }
            }
        }
    ]
}


{
    "error": {
        "code": 400,
        "message": "Invalid value at 'mutations[0].insert.key.path[0]' (oneof), oneof field 'id_type' is already set. Cannot set 'name'",
        "status": "INVALID_ARGUMENT",
        "details": [
            {
                "@type": "type.googleapis.com/google.rpc.BadRequest",
                "fieldViolations": [
                    {
                        "field": "mutations[0].insert.key.path[0]",
                        "description": "Invalid value at 'mutations[0].insert.key.path[0]' (oneof), oneof field 'id_type' is already set. Cannot set 'name'"
                    }
                ]
            }
        ]
    }
}

I have amended the following: "path": [ { "id": "1235629499534213120", "name": "id=1235629499534213120", "kind": "Log" } ] and now the error is this: { "error": { "code": 400, "message": "transactional commit requires a transaction", "status": "INVALID_ARGUMENT" } } — LCL

John John · Accepted Answer · 2017-06-19T21:59:03

Based on the docs, it looks like you should only be setting either a "name" or "id" in the Path Element, not both.

https://cloud.google.com/datastore/docs/reference/rest/v1/Key#PathElement

Error 400 when using Google API Explorer

2 Answers