How do you use the ghost API?

Using Ghost
1

I hate Python. I tried structuring requests for data to go into google sheets. Didn’t work. I tried doing it via cloudflare, but cloudflare stores secrets as objects instead of text strings.

For the life of me, I cannot figure out how to retrieve data using the Admin API Key. Creating a custom integration to get the key is easy. Using it is not.

I don’t understand why exporting members in a CSV does not export all data. Is the normal admin interface not secure? It has an option to delete the entire website, so it really should be secure.

Why can’t we have an admin API key that is read only? That would be less dangerous.

Does anyone have an example of a script that actually works?

2

Sorry, there are many questions here. Do you want to get the member list with a Python script? Is this the main question?

3

I would like to have access to the API tools without having to use Python. I find that program is really only useful to experienced engineers.

Being able to use Google Sheets or Cloudflare would be nice. Wondering if anyone has any code that actually works for reading data.

I would also like to see the creation of read-only keys, since that would be more secure.

4

Ghost is written with JavaScript. It’s official SDK for Admin API is also an NPM library.

In addition to Admin API, there is also Content API, which is a read-only API mostly used by public visitors or external consumers.

You can use both Content and Admin API with Cloudflare workers, if you want. I’m not aware of any tool or service that allows you to fetch your Ghost date inside Google Sheets though.

5

n8n and Ghost is pretty straight forward. That’s how I use the API / Webhook.

You can extend it further with other third parties as well.

For example, I have it set when a new customer is generated in Stripe > Email via Mailgun (Welcome)

At one point, I had a forum and integrated registrations between Flarum and Ghost this way too.

There are easy options out there!