Hi all.
This is my first post. I hope I can make it as explicit as possible.
I am using Get & Transform to load a table that has three parts. Relevant links are shown below:
http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=1&ts=1493041844740&position='O'&playerType=ALL
http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=2&ts=1493041933644&position='O'&playerType=ALL
http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=3&ts=1493041905532&position='O'&playerType=ALL
Please notice that the links are different only by two parameters: Page and TS. The page parameter specifies the table lines to load: page 1 shows values from lines 1 to 50, page 2 shows values from lines 51 to 100, and page three the remaining lines. I have not been able to find the function of the parameter ts, but I assume it is related to date/time, as it increases with later clicks (TimeStamp?).
When i try to load to excel these three links using Get & Transform I can only manage to get the first 50 lines (first part of the table) three different times.
Please let me know how to ensure I can get the second and third parts of the tables loaded into excel.
Many thanks.
Amenus .
This is my first post. I hope I can make it as explicit as possible.
I am using Get & Transform to load a table that has three parts. Relevant links are shown below:
http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=1&ts=1493041844740&position='O'&playerType=ALL
http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=2&ts=1493041933644&position='O'&playerType=ALL
http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=3&ts=1493041905532&position='O'&playerType=ALL
Please notice that the links are different only by two parameters: Page and TS. The page parameter specifies the table lines to load: page 1 shows values from lines 1 to 50, page 2 shows values from lines 51 to 100, and page three the remaining lines. I have not been able to find the function of the parameter ts, but I assume it is related to date/time, as it increases with later clicks (TimeStamp?).
When i try to load to excel these three links using Get & Transform I can only manage to get the first 50 lines (first part of the table) three different times.
Please let me know how to ensure I can get the second and third parts of the tables loaded into excel.
Many thanks.
Amenus .