Dalai Lama
New Member
- Joined
- Nov 28, 2014
- Messages
- 1
Hello All! I'm a long-time reader, first time poster. I've always found answers to my questions but I have finally come up to an issue that isn't posted on the forums.
What - I'm trying to automate via macros obtaining data housed online. I cannot get access to the raw data so I have to go through the website, select the date range i need and then export it. I've been successful with creating the macro to obtain metrics from all but one site. The one site is run by JavaScript and I cannot figure out the direct url.
Does anyone have any ideas how I could identify the url that the JavaScript is accessing to get and export the data?
I'm fairly confident that none of the following information will aid in a solution but I'm putting it on here for that .01% chance it does have something to do with it:
When I go to the main report, I see all areas and the shortcut to export all data is: javascript:__doPostBack('ctl00$ContentPlaceHolderReport$lnkExport','')
The following three actions are used to expand down to my local area: javascript:ExpandCollapseHierarchy('ContentPlaceHolderReport_gvData', 'ContentPlaceHolderReport_gvData_lnkGridRow1_1', '1', '1', '', '');
javascript:ExpandCollapseHierarchy('ContentPlaceHolderReport_gvData', 'ContentPlaceHolderReport_gvData_lnkGridRow81_81', '81', '2', '', '');
javascript:ExpandCollapseHierarchy('ContentPlaceHolderReport_gvData', 'ContentPlaceHolderReport_gvData_lnkGridRow82_82', '82', '3', '', '');
This is the shortcut to the specific data I'm looking for: javascript:__doPostBack('ctl00$ContentPlaceHolderReport$gvData$ctl85$ctl31','')
Once in there, the shortcut to export the needed data is:
javascript:__doPostBack('ctl00$ContentPlaceHolderReport$lnkExport','')
What - I'm trying to automate via macros obtaining data housed online. I cannot get access to the raw data so I have to go through the website, select the date range i need and then export it. I've been successful with creating the macro to obtain metrics from all but one site. The one site is run by JavaScript and I cannot figure out the direct url.
Does anyone have any ideas how I could identify the url that the JavaScript is accessing to get and export the data?
I'm fairly confident that none of the following information will aid in a solution but I'm putting it on here for that .01% chance it does have something to do with it:
When I go to the main report, I see all areas and the shortcut to export all data is: javascript:__doPostBack('ctl00$ContentPlaceHolderReport$lnkExport','')
The following three actions are used to expand down to my local area: javascript:ExpandCollapseHierarchy('ContentPlaceHolderReport_gvData', 'ContentPlaceHolderReport_gvData_lnkGridRow1_1', '1', '1', '', '');
javascript:ExpandCollapseHierarchy('ContentPlaceHolderReport_gvData', 'ContentPlaceHolderReport_gvData_lnkGridRow81_81', '81', '2', '', '');
javascript:ExpandCollapseHierarchy('ContentPlaceHolderReport_gvData', 'ContentPlaceHolderReport_gvData_lnkGridRow82_82', '82', '3', '', '');
This is the shortcut to the specific data I'm looking for: javascript:__doPostBack('ctl00$ContentPlaceHolderReport$gvData$ctl85$ctl31','')
Once in there, the shortcut to export the needed data is:
javascript:__doPostBack('ctl00$ContentPlaceHolderReport$lnkExport','')