create an api route

[harishconti]

create an api route in app.py to fetch the application data w.r.t application_id as input

[ramyaakella]

So for this, do you expect to have a page that has the list of applied to jobs ( applications) and then on click on one of the application_id , fetches the application data ?

[harishconti]

• we can create a API method with json as response with application_id as input
• Later create a HTML Page to to dispaly the same data in table format by consuming above API

Let me know if you are intrested ?

[ramyaakella]

Yes, I would like to work on this issue

[harishconti]

@ramyaakella The data is fetched from gcloud if you want to access let me know your ip address will add to ip exception. Or you can work with json locally.

In discord share ip Username : harish_ng

[ramyaakella]

okay, I will work with the json first

[ramyaakella]

• Can I access the sql server , any other way, without using the IP address?
• When inserting data into applications table, not using application_id, can I assume that it is generated on its own ? And is the primary key ?

[harishconti]

@ramyaakella The data is fetched from gcloud if you want to access let me know your ip address will add to ip exception.

Or you can work with json locally.then u can create json saving option into temp folder instead of db.

Or let me create a local db image to be usable and update to repo.