Web Application for API creation

We need to write Web Application for API creation [login to view URL] it consumes rest api and files and creates rest api for down stream applications. Reqirement1: Export data from excel/csv and create table for selected columns. Excel might have col1, col2, col3, col4….coln. When we upload the file, user should see all the columns that are available. User will select required columns like col1,col4,… colx and user also gives table name. We should create table with the selected columns and selected table name. Requirement2: Export data from excel to existed table for selected columns. When we upload the file, we also select one of the available tables. We display excel columns onside and db table columns one side. We should be able to map and create the data. We should be able to backup original table. Requirement3: Create API entry. We should be able to create API details like end point, key, parameters, name of the api. These are the API entries we will select in the Requirement 4 Reqirement4: Call rest service and create table for selected json fields. Response might have col1, col2, col3, col4….coln. When we call rest service, user should see all the fields that are available in response. User will select required fields like col1, col4, colx and user also gives table name. We should create table with the selected columns and selected table name. Requirement5: Call rest service and populate data to existed table for selected fields. When we call the service, we also select one of the available tables. We display service response columns onside and db table columns one side. We should be able to map and create the data. We should be able to backup original table. Requirement6: Call rest service and populate data to existed table for preselected fields as batch process We need to create a batch process which will update existing table from preselected rest service and fields. Batch job has to backup existing table before updating it. Requrement7: Visually join table apply filters on existing tables and create new tables. Requirement8: Create API on selected tables. These APIs will be used in mobile app. 1. Service1 : Return urls of all the apis 2. Service2: Return Response based on the urls that are available in service1.