Ghost experimental admin API db endpoint - JSON export

[gozzy]

So, I came across the knowledge that we can backup our blog via the JSON import/export functionality introduced in Ghost v2, I’m looking to automate this process and I know afew repos exist currently but they do not incubate my custom locally hosted instance of Ghost.

Backup best practices

The export can be also done through experimental /db endpoints in Admin API if you are looking for automation (note experimental would mean you’d need to keep an eye on any upcoming changes). Most of the tables are needed but some are excluded for security reasons. In theory, if you are ok creating a dump of the whole database and are sure the data will be stored securely, then there’s no one to stop you

@naz mentions here there is a endpoint in the admin API known as “db” so I went ahead and generated a JWT to give it a shot, knowing this is zero documentation on this for it’s experimental “phase”.

Whenever I call the POST request i’m welcome with:

{
"errors": [
    {
        "message": "Please select a database file to import.",
        "context": null,
        "type": "ValidationError",
        "details": null,
        "property": null,
        "help": null,
        "code": null,
        "id": "9ad46300-fdbc-11e9-8540-bb7912061736"
    }
]

}

So how can I configure my POST request to export instead of import?

[vikaspotluri123]

You should be making a GET request, not a POST request

TryGhost/Ghost/blob/6b420d0cbd2ae6e85b1c46bb07849049da8a9223/core/server/web/api/v2/admin/routes.js#L123

[gozzy]

I’m getting this response?

{
"errors": [
    {
        "message": "The server does not support the functionality required to fulfill the request.",
        "context": null,
        "type": "NotImplementedError",
        "details": null,
        "property": null,
        "help": null,
        "code": null,
        "id": "6e86f100-fdc6-11e9-8540-bb7912061736"
    }
]

}

[vikaspotluri123]

It looks like that endpoint isn’t available for integrations; you’ll need to use User Authentication

https://ghost.org/docs/api/v3/admin/#user-authentication

[gozzy]

Still facing the “NotImplementedError” even after verifying that my user auth cookies are in my delegated call.

Using Postman to test.

[vikaspotluri123]

Just checking, you’re not sending the Auth header, correct? As far as I know, the export db option in the Admin interface hits that endpoint. You might compare the request you’re making with what the admin request makes and see what differs.

Here’s the logic for not implemented FWIW:

https://github.com/TryGhost/Ghost/blob/master/core/server/web/api/v2/admin/middleware.js#L5-L44

[gozzy]

You legend, not including the auth header did the trick!

Thank you