'Work around for JSON data import in Google Sheet using custom script
I want to import data from a table within an HTML page. Used IMPORTHTML
=IMPORTHTML("https://www.fpi.nsdl.co.in/web/Reports/FPI_Fortnightly_Selection.aspx","table",1)
It doesn't give result.
When I Dug deep, found out JSON is used for data.
Searched Stackflow. Found some similar cases.
Seeking help in building custom function which import data with headers references stored in cell of Google Sheet. And importing only desired columns only.
Pl. refer the pics. It is using aspNetHidden Class. Could not find any reference to overcome this in Google Sheets (& App script). Any Help would be great. Pl. follow the weblink to explore in depth of following web page details. https://www.fpi.nsdl.co.in/web/Reports/FPI_Fortnightly_Selection.aspx
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|