server which can handle multiple operations without changing master server. user needs to add only single script in scripts folder based on project requirement.
Example: post api: https://192.168.1.4:4000/exercise
user will pass api along with script name. Request: { "scriptName": "excersice1", "url": "https://sdw-wsrest.ecb.europa.eu/service/data/EXR/M.GBP.EUR.SP00.A?detail=dataonly" }
Application will read data using api, convert it into pandas dataframe, and in response, html of requested dataframe will be given.
Response: { "data": "<table border="1" class="dataframe">\n \n <tr style="text-align: right;">\n \n TIME_PERIOD\n OBS_VALUE\n \n \n \n \n 0\n 1999-01\n 0.702913\n \n \n 1\n 1999-02\n 0.688505\n \n \n 2\n 1999-03\n 0.671270\n \n \n 3\n 1999-04\n 0.665018\n \n \n 4\n 1999-05\n 0.658252\n \n \n 5\n 1999-06\n 0.650255\n \n \n 6\n 1999-07\n 0.657791\n \n \n 7\n 1999-08\n 0.660136\n \n \n 8\n 1999-09\n 0.646832\n \n \n 9\n 1999-10\n 0.645871\n \n \n 10\n 1999-11\n 0.637018\n \n \n 11\n 1999-12\n 0.626509\n \n \n 12\n 2000-01\n 0.618338\n \n \n 13\n 2000-02\n 0.614657\n \n \n 14\n 2000-03\n 0.610626\n \n \n 15\n 2000-04\n 0.598017\n \n \n 16\n 2000-05\n 0.601509\n \n \n 17\n 2000-06\n 0.629268\n \n \n 18\n 2000-07\n 0.623043\n \n \n 19\n 2000-08\n 0.607096\n \n \n 20\n 2000-09\n 0.607729\n \n \n 21\n 2000-10\n 0.589327\n \n \n 22\n 2000-11\n 0.600386\n \n \n 23\n 2000-12\n 0.613421\n \n \n 24\n 2001-01\n 0.634800\n \n \n 25\n 2001-02\n 0.633995\n \n \n 26\n 2001-03\n 0.629145\n \n \n 27\n 2001-04\n 0.621684\n \n \n 28\n 2001-05\n 0.613282\n \n \n 29\n 2001-06\n 0.608905\n \n \n 30\n 2001-07\n 0.608568\n \n \n 31\n 2001-08\n 0.626717\n \n \n 32\n 2001-09\n 0.622910\n \n \n 33\n 2001-10\n 0.623935\n \n \n 34\n 2001-11\n 0.618375\n \n \n 35\n 2001-12\n 0.620119\n \n \n 36\n 2002-01\n 0.616593\n \n \n 37\n 2002-02\n 0.611603\n \n \n 38\n 2002-03\n 0.615735\n \n \n 39\n 2002-04\n 0.614071\n \n \n 40\n 2002-05\n 0.628227\n \n \n 41\n 2002-06\n 0.644050\n \n \n 42\n 2002-07\n 0.638700\n \n \n 43\n 2002-08\n 0.636332\n \n \n 44\n 2002-09\n 0.630588\n \n \n 45\n 2002-10\n 0.629941\n \n \n 46\n 2002-11\n 0.637086\n \n \n 47\n 2002-12\n 0.642175\n \n \n 48\n 2003-01\n 0.657109\n \n \n 49\n 2003-02\n 0.669772\n \n \n 50\n 2003-03\n 0.682548\n \n \n 51\n 2003-04\n 0.689020\n \n \n 52\n 2003-05\n 0.713219\n \n \n 53\n 2003-06\n 0.702240\n \n \n 54\n 2003-07\n 0.700448\n \n \n 55\n 2003-08\n 0.699193\n \n \n 56\n 2003-09\n 0.696927\n \n \n 57\n 2003-10\n 0.697630\n \n \n 58\n 2003-11\n 0.692778\n \n \n 59\n 2003-12\n 0.701957\n \n \n 60\n 2004-01\n 0.692145\n \n \n 61\n 2004-02\n 0.676898\n \n \n 62\n 2004-03\n 0.671241\n \n \n 63\n 2004-04\n 0.665325\n \n \n 64\n 2004-05\n 0.671574\n \n \n 65\n 2004-06\n 0.664282\n \n \n 66\n 2004-07\n 0.665757\n \n \n 67\n 2004-08\n 0.669418\n \n \n 68\n 2004-09\n 0.681298\n \n \n 69\n 2004-10\n 0.691440\n \n \n 70\n 2004-11\n 0.698620\n \n \n 71\n 2004-12\n 0.695000\n \n \n 72\n 2005-01\n 0.698667\n \n \n 73\n 2005-02\n 0.689680\n \n \n 74\n 2005-03\n 0.692331\n \n \n 75\n 2005-04\n 0.682933\n \n \n 76\n 2005-05\n 0.683993\n \n \n 77\n 2005-06\n 0.668948\n \n \n 78\n 2005-07\n 0.687564\n \n \n 79\n 2005-08\n 0.685270\n \n \n 80\n 2005-09\n 0.677595\n \n \n 81\n 2005-10\n 0.681367\n \n \n 82\n 2005-11\n 0.679332\n \n \n 83\n 2005-12\n 0.679221\n \n \n 84\n 2006-01\n 0.685984\n \n \n 85\n 2006-02\n 0.682972\n \n \n 86\n 2006-03\n 0.689348\n \n \n 87\n 2006-04\n 0.694628\n \n \n 88\n 2006-05\n 0.683295\n \n \n 89\n 2006-06\n 0.686659\n \n \n 90\n 2006-07\n 0.687819\n \n \n 91\n 2006-08\n 0.676687\n \n \n 92\n 2006-09\n 0.675107\n \n \n 93\n 2006-10\n 0.672543\n \n \n 94\n 2006-11\n 0.673968\n \n \n 95\n 2006-12\n 0.672861\n \n \n 96\n 2007-01\n 0.663407\n \n \n 97\n 2007-02\n 0.668003\n \n \n 98\n 2007-03\n 0.680211\n \n \n 99\n 2007-04\n 0.679337\n \n \n 100\n 2007-05\n 0.681356\n \n \n 101\n 2007-06\n 0.675624\n \n \n 102\n 2007-07\n 0.674400\n \n \n 103\n 2007-08\n 0.677663\n \n \n 104\n 2007-09\n 0.688870\n \n \n 105\n 2007-10\n 0.696141\n \n \n 106\n 2007-11\n 0.708959\n \n \n 107\n 2007-12\n 0.720637\n \n \n 108\n 2008-01\n 0.747250\n \n \n 109\n 2008-02\n 0.750938\n \n \n 110\n 2008-03\n 0.774939\n \n \n 111\n 2008-04\n 0.794866\n \n \n 112\n 2008-05\n 0.792086\n \n \n 113\n 2008-06\n 0.791524\n \n \n 114\n 2008-07\n 0.793076\n \n \n 115\n 2008-08\n 0.792788\n \n \n 116\n 2008-09\n 0.799243\n \n \n 117\n 2008-10\n 0.786680\n \n \n 118\n 2008-11\n 0.830632\n \n \n 119\n 2008-12\n 0.904476\n \n \n 120\n 2009-01\n 0.918193\n \n \n 121\n 2009-02\n 0.886910\n \n \n 122\n 2009-03\n 0.919664\n \n \n 123\n 2009-04\n 0.897560\n \n \n 124\n 2009-05\n 0.884445\n \n \n 125\n 2009-06\n 0.856700\n \n \n 126\n 2009-07\n 0.860920\n \n \n 127\n 2009-08\n 0.862655\n \n \n 128\n 2009-09\n 0.891348\n \n \n 129\n 2009-10\n 0.915566\n \n \n 130\n 2009-11\n 0.898924\n \n \n 131\n 2009-12\n 0.899717\n \n \n 132\n 2010-01\n 0.883050\n \n \n 133\n 2010-02\n 0.876042\n \n \n 134\n 2010-03\n 0.901602\n \n \n 135\n 2010-04\n 0.874555\n \n \n 136\n 2010-05\n 0.857144\n \n \n 137\n 2010-06\n 0.827707\n \n \n 138\n 2010-07\n 0.835657\n \n \n 139\n 2010-08\n 0.823632\n \n \n 140\n 2010-09\n 0.839866\n \n \n 141\n 2010-10\n 0.876376\n \n \n 142\n 2010-11\n 0.855095\n \n \n 143\n 2010-12\n 0.848128\n \n \n 144\n 2011-01\n 0.847117\n \n \n 145\n 2011-02\n 0.846355\n \n \n 146\n 2011-03\n 0.866533\n \n \n 147\n 2011-04\n 0.882913\n \n \n 148\n 2011-05\n 0.877877\n \n \n 149\n 2011-06\n 0.887448\n \n \n 150\n 2011-07\n 0.884760\n \n \n 151\n 2011-08\n 0.876685\n \n \n 152\n 2011-09\n 0.871723\n \n \n 153\n 2011-10\n 0.870360\n \n \n 154\n 2011-11\n 0.857395\n \n \n 155\n 2011-12\n 0.844055\n \n \n 156\n 2012-01\n 0.832102\n \n \n 157\n 2012-02\n 0.836960\n \n \n 158\n 2012-03\n 0.834482\n \n \n 159\n 2012-04\n 0.821884\n \n \n 160\n 2012-05\n 0.803708\n \n \n 161\n 2012-06\n 0.805793\n \n \n 162\n 2012-07\n 0.788266\n \n \n 163\n 2012-08\n 0.788837\n \n \n 164\n 2012-09\n 0.798211\n \n \n 165\n 2012-10\n 0.806652\n \n \n 166\n 2012-11\n 0.803889\n \n \n 167\n 2012-12\n 0.812368\n \n \n 168\n 2013-01\n 0.832709\n \n \n 169\n 2013-02\n 0.862498\n \n \n 170\n 2013-03\n 0.859955\n \n \n 171\n 2013-04\n 0.850757\n \n \n 172\n 2013-05\n 0.849143\n \n \n 173\n 2013-06\n 0.851910\n \n \n 174\n 2013-07\n 0.861924\n \n \n 175\n 2013-08\n 0.859041\n \n \n 176\n 2013-09\n 0.841710\n \n \n 177\n 2013-10\n 0.847198\n \n \n 178\n 2013-11\n 0.837802\n \n \n 179\n 2013-12\n 0.836387\n \n \n 180\n 2014-01\n 0.826743\n \n \n 181\n 2014-02\n 0.825099\n \n \n 182\n 2014-03\n 0.831698\n \n \n 183\n 2014-04\n 0.825195\n \n \n 184\n 2014-05\n 0.815347\n \n \n 185\n 2014-06\n 0.804090\n \n \n 186\n 2014-07\n 0.793104\n \n \n 187\n 2014-08\n 0.797301\n \n \n 188\n 2014-09\n 0.791132\n \n \n 189\n 2014-10\n 0.788609\n \n \n 190\n 2014-11\n 0.790535\n \n \n 191\n 2014-12\n 0.788300\n \n \n 192\n 2015-01\n 0.766798\n \n \n 193\n 2015-02\n 0.740507\n \n \n 194\n 2015-03\n 0.723584\n \n \n 195\n 2015-04\n 0.721158\n \n \n 196\n 2015-05\n 0.721241\n \n \n 197\n 2015-06\n 0.720780\n \n \n 198\n 2015-07\n 0.706850\n \n \n 199\n 2015-08\n 0.714232\n \n \n 200\n 2015-09\n 0.731289\n \n \n 201\n 2015-10\n 0.732870\n \n \n 202\n 2015-11\n 0.706576\n \n \n 203\n 2015-12\n 0.725952\n \n \n 204\n 2016-01\n 0.754586\n \n \n 205\n 2016-02\n 0.775585\n \n \n 206\n 2016-03\n 0.780201\n \n \n 207\n 2016-04\n 0.792296\n \n \n 208\n 2016-05\n 0.777791\n \n \n 209\n 2016-06\n 0.790494\n \n \n 210\n 2016-07\n 0.841058\n \n \n 211\n 2016-08\n 0.855209\n \n \n 212\n 2016-09\n 0.852277\n \n \n 213\n 2016-10\n 0.893900\n \n \n 214\n 2016-11\n 0.868943\n \n \n 215\n 2016-12\n 0.844414\n \n \n 216\n 2017-01\n 0.861004\n \n \n 217\n 2017-02\n 0.852730\n \n \n 218\n 2017-03\n 0.865603\n \n \n 219\n 2017-04\n 0.848235\n \n \n 220\n 2017-05\n 0.855543\n \n \n 221\n 2017-06\n 0.877238\n \n \n 222\n 2017-07\n 0.886173\n \n \n 223\n 2017-08\n 0.911207\n \n \n 224\n 2017-09\n 0.894701\n \n \n 225\n 2017-10\n 0.890714\n \n \n 226\n 2017-11\n 0.887945\n \n \n 227\n 2017-12\n 0.882649\n \n \n 228\n 2018-01\n 0.883311\n \n \n 229\n 2018-02\n 0.883964\n \n \n 230\n 2018-03\n 0.882870\n \n \n 231\n 2018-04\n 0.872121\n \n \n 232\n 2018-05\n 0.877258\n \n \n 233\n 2018-06\n 0.878860\n \n \n 234\n 2018-07\n 0.887255\n \n \n 235\n 2018-08\n 0.896869\n \n \n 236\n 2018-09\n 0.892807\n \n \n 237\n 2018-10\n 0.882721\n \n \n 238\n 2018-11\n 0.881181\n \n \n 239\n 2018-12\n 0.897742\n \n \n 240\n 2019-01\n 0.886030\n \n \n 241\n 2019-02\n 0.872637\n \n \n 242\n 2019-03\n 0.858220\n \n \n 243\n 2019-04\n 0.861789\n \n \n 244\n 2019-05\n 0.871758\n \n \n 245\n 2019-06\n 0.891073\n \n \n 246\n 2019-07\n 0.899420\n \n \n 247\n 2019-08\n 0.915538\n \n \n 248\n 2019-09\n 0.890916\n \n \n 249\n 2019-10\n 0.875386\n \n \n 250\n 2019-11\n 0.857609\n \n \n 251\n 2019-12\n 0.847307\n \n \n 252\n 2020-01\n 0.849273\n \n \n 253\n 2020-02\n 0.840946\n \n \n 254\n 2020-03\n 0.894595\n \n \n 255\n 2020-04\n 0.875469\n \n \n 256\n 2020-05\n 0.886853\n \n \n 257\n 2020-06\n 0.898781\n \n \n 258\n 2020-07\n 0.904667\n \n \n 259\n 2020-08\n 0.900809\n \n \n 260\n 2020-09\n 0.909474\n \n \n 261\n 2020-10\n 0.907411\n \n \n 262\n 2020-11\n 0.896053\n \n \n 263\n 2020-12\n 0.906244\n \n \n 264\n 2021-01\n 0.892665\n \n \n 265\n 2021-02\n 0.872683\n \n \n 266\n 2021-03\n 0.858732\n \n \n 267\n 2021-04\n 0.865268\n \n \n 268\n 2021-05\n 0.862583\n \n \n 269\n 2021-06\n 0.858720\n \n \n 270\n 2021-07\n 0.856130\n \n \n 271\n 2021-08\n 0.852874\n \n \n 272\n 2021-09\n 0.856833\n \n \n 273\n 2021-10\n 0.846944\n \n \n 274\n 2021-11\n 0.847864\n \n \n 275\n 2021-12\n 0.848748\n \n \n 276\n 2022-01\n 0.835034\n \n \n 277\n 2022-02\n 0.837873\n \n \n", "message": "Successful operation", "return_code": 0 }
Note: in case of error, application will return errorcode along with error line no as data.