Hasura Data API + Postman Collection

By

After doing data modelling for my app, I moved to next task in the third week. The task was to learn how to make CRUD queries across all your tables using Hasura Data APIs.


My previous blog post is about data modelling for my app, check it out to understand database schema for my app.

What is an API

Application program interface (API) is a set of routines, protocols, and tools for building software applications. An API specifies how software components should interact and APIs are used when programming graphical user interface (GUI) components.
Hasura provides Data API as well as Auth API on their platform. Before integration of the app with database, first I need to check the APIs and learn how that works. To know more about Hasura Data APIs, refer to this link.
Data service on hasura platform runs as any other service like my app. We need to contact to this data service in order to exchange data to/from the database tables. I used a third party app named Postman, although you can use curl command from Linux terminal, but Postman makes things easy for us because of its GUI interaction. Postman is easy to install and easy to learn. I used this videos to understand the basics API request and response in Postman.

Query using Postman

All query to data service must be in JSON format, and response from the data service is also in JSON, so we need to convert the regular SQL query into JSON format. For example
Regular SQL query: select * from messages order by created;

In Json, it becomes
On sending that data using postman, response from data api is also in json format.



Above is a simple example of retrieving data from a table. We can also make query to insert a new data, delete and update some data.


API Explorer on Hasura Console

Since postman gives trial for only 7 days, but if you are using new console, you can use their API explorer. Search for query and you will get a tempelate.

Insert

This is a simple insertion in a table named user_info, in which there are four columns id, username, name and about. I made a simple query and in that I also put returning option. Response of that query is shown in the right side of the picture.


Select

This is also a simple query to select some data from a table. Here I am selecting all columns from user_info table.


We can not create tables using the query to Auth APIs, because if we need to, we have to put the admin credentials in the application code and it is bad practice. Better to create required tables from the Hasura Console.


What's Next?

My next post is about Hasura Auth API and + Postman collection.

Comments

Post a Comment

Popular posts from this blog

User Feedback & Testing of White Board

By
Image
As in my previous posts, I’ve described about all screens of my app  White Board.  You can check here — App Screen 1 (UI + Backend Integration) If you are familiar with my previous post and app idea then you know what I did before, otherwise just check my app… medium.com App Screen 2 (UI + Backend Integration) Task 5.1 Hasura Internship. Week 5 task medium.com App Screen 3 (UI + Backend Integration) Task 6.1 Hasura Internship Week 6 Task medium.com This one is for user feedback about my app and testing of the app for any bug. When I completed my app with required functionality as I described in MVP in my first blog post at the beginning of my journey. Idea for an APP | First step to internship This article is about my brainstorming for an idea which can be used an MVP. medium.com Testing and fixing bugs is one of the important part in order to build a successful application. Anyhow a person can’t do this all alone, so it is a better way to get feedback from others as w
Read more

Idea for an app | First step to internship

By
Image
It all started when I joined IMAD (Introduction to Modern Application Developement), an MOOC provided by NPTEL in association with Hasura. I completed the assignments and appeared in the final test, scoring an overall of 84%, which, much to my delight, landed me an internship with Hasura. First week task The task in the first week was to come up with an idea for an app that can be demonstrated and used as a Minimum Viable Product (MVP) with just 3 screens. I discussed this task with a few of my friends and researched the internet for viable ideas. After long sessions of discussion and surfing the internet, I finally settled on the idea for an app for a  Collaborative   White Board . The idea   The idea of the app is pretty simple, to create an online platform for collaborative brainstorming by a group/team of people from across the globe. This sort of brainstorming is usually required for startup ideas, projects or the onset of any form of development in a group.
Read more

Playing with the Octo-Cat

By
Image
After I done with setting-up dev environment, next task of Hasura Internship was to learn git basics. https://octodex.github.com/images/dojocat.jpg Git is not a programming language or an IDE About Git Git is the most commonly used  distributed version control system . Git is a mature, actively maintained open source project originally developed in 2005 by Linus Torvalds, the famous creator of the Linux operating system kernel.  GitHub  is a company that provides a platform to do version controlling Git allows a team of people to work together, all using the same files. And it helps the team cope with the confusion that tends to happen when multiple people are editing the same files. Version control in simple terms is nothing but making flags/check points as significant changes are made to your code/work so that you can always go back to whichever version was last working properly or whichever version you want to use at the moment. Why Git and Github? Version contr
Read more