Simple example api fetcher app This script make periodically requests to api and save result to database
create collection test - (id,uid,name) with one row:
id - autogenerated,
uid - 1,
name - Rick Sanchez
git clone https://github.com/alelipona/simple-from-api-to-database.git
cd simple-from-api-to-database
npm install
create file .env with following:
POCKETBASE_HOST=https://your-pockethost-account.pockethost.io
POCKETBASE_USER=your-collection-admin-user
POCKETBASE_PASSWORD=your-collection-admin-password
API_ENDPOINT=https://rickandmortyapi.com/graphql
check if you test pocketbase collection with one row available and then:
node app.js
some from log:
data: {
collectionId: 'wfoh8t2zrsm3ub3',
collectionName: 'test',
created: '2023-03-24 13:08:44.601Z',
id: '7mm6cxa025ozd1f',
name: 'Abadango Cluster Princess',
uid: 6,
updated: '2023-03-24 13:08:44.601Z'
}
get data from api and save