Hi,
I am trying to create a web connection to a website that has a drop down with a list of plan id's.
The drop down list on the website refreshes several times a week and i want to pass a parameter that selects the plan id at the very top of the drop down list.
Unfortunately the plan id's are generated at random so it's not possible to create a cell reference to pull the latest id.
Here is an example of the url (for security purposes this isn't a live url) - is there anyway to pass a parameter that would automatically select the latest plan id highlighted in red below (i.e. the 1st item in the drop down)?
https://capacity.com/new_storage_metric#new_storage_metric:leid=102;from=2017-10-01;to=2017-12-30;PLAN1=53605;binType=Bulk%20Stock!Case%20Flow!Drawer!Flat%20Apparel!Hanger%20Rod!Hangers!Jewelry!Library!Library%20Deep!Not%20In%20Bin!Prime%20Pallet!Random%20Other%20Bin!Reserve%20Pallet!Shoes;volumeType=NET_VOLUME;volumeUnitType=CUBIC_FEET;pthreshold=100
I am trying to create a web connection to a website that has a drop down with a list of plan id's.
The drop down list on the website refreshes several times a week and i want to pass a parameter that selects the plan id at the very top of the drop down list.
Unfortunately the plan id's are generated at random so it's not possible to create a cell reference to pull the latest id.
Here is an example of the url (for security purposes this isn't a live url) - is there anyway to pass a parameter that would automatically select the latest plan id highlighted in red below (i.e. the 1st item in the drop down)?
https://capacity.com/new_storage_metric#new_storage_metric:leid=102;from=2017-10-01;to=2017-12-30;PLAN1=53605;binType=Bulk%20Stock!Case%20Flow!Drawer!Flat%20Apparel!Hanger%20Rod!Hangers!Jewelry!Library!Library%20Deep!Not%20In%20Bin!Prime%20Pallet!Random%20Other%20Bin!Reserve%20Pallet!Shoes;volumeType=NET_VOLUME;volumeUnitType=CUBIC_FEET;pthreshold=100
