Here's the scrape referenced in the images above. Unfortunately I can't provide access to the site for troubleshooting, as the data is behind authentication.
{
"_id": "bret_scrape_path_1",
"startUrl": [
"https://localhost.com/erfp/searchRfp.do?action=search&searchCriteriaVo.DateFrom=09%2F19%2F2018"
],
"selectors": [
{
"id": "QUERY_TABLE_ROW",
"type": "SelectorElement",
"parentSelectors": [
"_root"
],
"selector": "#divContentH div table tr:nth-of-type(n+3)",
"multiple": true,
"delay": "7000"
},
{
"id": "RFP_ID",
"type": "SelectorLink",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "a",
"multiple": false,
"delay": 0
},
{
"id": "BRET_ID",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(2)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "PARENT_STATUS",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(3)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "RELATED_RFPs",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(4)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "PROSPECT_NAME",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(5)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "ERFP_STATE",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(6)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "EPM_STATE",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(7)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "BRET_STATE",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(8)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "BRET_STATE_TIMESTAMP",
"type": "SelectorElementAttribute",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(8)",
"multiple": false,
"extractAttribute": "title",
"delay": 0
},
{
"id": "NUM_EEs",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(9)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "TLM_STATE",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(10)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "ETS_STATE",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(11)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "ADP_UW",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(12)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "AP_REGION",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(13)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "REV_CENTER",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(14)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "PAYGROUP",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(15)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "PARENT",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.smcopy:nth-of-type(16)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "FEIN",
"type": "SelectorText",
"parentSelectors": [
"QUERY_TABLE_ROW"
],
"selector": "td.border_bottom.border_right.smcopy",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "CLIENT_DBA",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.prospectBusiness']",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "CLIENT_ADDRESS",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.prospectAddr1']",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "CLIENT_ADDRESS1",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.prospectAddr2']",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "CLIENT_CITY",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.prospectCity']",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "CLIENT_STATE",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.prospectState'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "CLIENT_ZIP",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.prospectZip']",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "LEAD_SOURCE",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name ='demographicsVo.leadId'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "LEAD_SOURCE_DETAIL",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.leadSourceDetailId'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "BROKER_TYPE",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.brokerType'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "BROKER_NAME",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.brokerId'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "AGENT_NAME",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.brokerAgentId'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "BROKER_LOCATION",
"type": "SelectorText",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.brokerLocationId'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "IS_NOT_EXISTING_CLIENT",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.hasAdpAffiliation']:nth-of-type(2)",
"multiple": false,
"extractAttribute": "checked",
"delay": 0
},
{
"id": "PARENT_ID",
"type": "SelectorElementAttribute",
"parentSelectors": [
"RFP_ID"
],
"selector": "[name = 'demographicsVo.parentTsCode'] ",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "CONTACTS_LINK",
"type": "SelectorElementClick",
"parentSelectors": [
"RFP_ID"
],
"selector": "tr:nth-of-type(2)",
"multiple": false,
"delay": "2500",
"clickElementSelector": "td.copy table:contains('Contacts') a",
"clickType": "clickOnce",
"discardInitialElements": true,
"clickElementUniquenessType": "uniqueText"
},
{
"id": "DM_NAME",
"type": "SelectorText",
"parentSelectors": [
"CONTACTS_LINK"
],
"selector": "td tr:nth-of-type(2) td.smcopy:nth-of-type(2)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "OFFICE",
"type": "SelectorText",
"parentSelectors": [
"CONTACTS_LINK"
],
"selector": "tr:nth-of-type(3) td.smcopy:nth-of-type(2)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "REGION",
"type": "SelectorText",
"parentSelectors": [
"CONTACTS_LINK"
],
"selector": "tr:nth-of-type(2) td.smcopy:nth-of-type(6)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "CENSUS_LINK",
"type": "SelectorElementClick",
"parentSelectors": [
"CONTACTS_LINK"
],
"selector": "",
"multiple": false,
"delay": "2000",
"clickElementSelector": "td.copy table:contains('BRET Census') a",
"clickType": "clickOnce",
"discardInitialElements": true,
"clickElementUniquenessType": "uniqueText"
},
{
"id": "CURRENT_CARRIERS",
"type": "SelectorGroup",
"parentSelectors": [
"CENSUS_LINK"
],
"selector": "td.label.border_left td:nth-of-type(3) option",
"delay": 0,
"extractAttribute": ""
},
{
"id": "PEO",
"type": "SelectorText",
"parentSelectors": [
"CENSUS_LINK"
],
"selector": "td.smcopy.border_top:nth-of-type(6)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "SIC_CODE",
"type": "SelectorElementAttribute",
"parentSelectors": [
"CENSUS_LINK"
],
"selector": "input#sic",
"multiple": false,
"extractAttribute": "value",
"delay": 0
},
{
"id": "NAICS_CODE",
"type": "SelectorText",
"parentSelectors": [
"CENSUS_LINK"
],
"selector": "select#naicsCodeSelect option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "QUESTIONNAIRE_LINK",
"type": "SelectorElementClick",
"parentSelectors": [
"CENSUS_LINK"
],
"selector": "",
"multiple": false,
"delay": "9000",
"clickElementSelector": "td.copy table:contains('BRET Questionnaire') a",
"clickType": "clickOnce",
"discardInitialElements": true,
"clickElementUniquenessType": "uniqueText"
},
{
"id": "COVERAGE_EMP",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(2):contains('Employee') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "COVERAGE_ES",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(3):contains('Employee+Spouse') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "COVERAGE_EC",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(4):contains('Employee+Children') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "COVERAGE_EF",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(5):contains('Employee+Family') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "COVERAGE_NONE",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(6):contains('No Coverage') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "COVERAGE_TERM",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(7):contains('Terminated') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "AS_FACTOR",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(2):contains('Age/Sex Factor') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "IND_FACTOR",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(3):contains('Industry Factor') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "ASI_SCORE",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "tr:nth-of-type(4):contains('Age/Sex/Industry') td.smcopy.border_right",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "EXISTING_MEDICAL",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "select#question_3.smcopy option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "MESSAGE_HISTORY",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "td.smcopy:contains('Message History:')",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "NOTES",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "td.smcopy:contains('Notes:')",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "SELF_INSURED",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "[name='question_15'] option:checked",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "RENEWAL_DATE",
"type": "SelectorHTML",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "#questionnaire tr:contains('b. What is the medical renewal date?') td.label:nth-of-type(2)",
"multiple": false,
"regex": "(?<=value=")([0-9]|/)+",
"delay": 0
},
{
"id": "NUM_RENEWALS",
"type": "SelectorHTML",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "#questionnaire tr:contains('c. How many renewals') td.label:nth-of-type(2)",
"multiple": false,
"regex": "(?<=value=")([0-9])+",
"delay": 0
},
{
"id": "LAST_RENEWAL_INCREASE",
"type": "SelectorHTML",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "#questionnaire tr:contains('d. What was the last renewal') td.label:nth-of-type(2)",
"multiple": false,
"regex": "(?<=value=")([0-9])+",
"delay": 0
},
{
"id": "UPCOMING_RENEWAL_INCREASE",
"type": "SelectorHTML",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "#questionnaire tr:contains('e. What is the upcoming renewal') td.label:nth-of-type(2)",
"multiple": false,
"regex": "(?<=value=")([0-9])+",
"delay": 0
},
{
"id": "DISABLED_WC_COUNT",
"type": "SelectorHTML",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "#questionnaire tr:contains('3. How many employees are not actively at work') td.label:nth-of-type(2)",
"multiple": false,
"regex": "(?<=value=")([0-9])+",
"delay": 0
},
{
"id": "COVERAGE_WAIVED_RATIO",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "table:nth-child(9) tbody tr:nth-child(3) td table tbody tr:nth-child(2) td",
"multiple": false,
"regex": "([0-9])+",
"delay": 0
},
{
"id": "COVERAGE_COBRA_RATIO",
"type": "SelectorText",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "td.label:contains('Total COBRA Participants')",
"multiple": false,
"regex": "([0-9])+",
"delay": 0
},
{
"id": "ERFPSUMMARY_LINK",
"type": "SelectorElementClick",
"parentSelectors": [
"QUESTIONNAIRE_LINK"
],
"selector": "",
"multiple": false,
"delay": "1500",
"clickElementSelector": "td.copy table:contains('eRFP Summary') a",
"clickType": "clickOnce",
"discardInitialElements": true,
"clickElementUniquenessType": "uniqueText"
},
{
"id": "SALES_COORDINATOR",
"type": "SelectorText",
"parentSelectors": [
"ERFPSUMMARY_LINK"
],
"selector": "table:contains('eRFP Summary') table:nth-of-type(1) tr:contains('Sales Coordinator') td.smcopy",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "TLM_SALES_LINK",
"type": "SelectorElementClick",
"parentSelectors": [
"ERFPSUMMARY_LINK"
],
"selector": "",
"multiple": false,
"delay": "2000",
"clickElementSelector": "td.copy table:contains('TLM Sales') a",
"clickType": "clickOnce",
"discardInitialElements": true,
"clickElementUniquenessType": "uniqueText"
},
{
"id": "SALES_EXECUTIVE",
"type": "SelectorText",
"parentSelectors": [
"TLM_SALES_LINK"
],
"selector": "#mainTBody table table tr:contains('SE/SD Name:') td:nth-of-type(2)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "SALES_EXECUTIVE_EMAIL",
"type": "SelectorText",
"parentSelectors": [
"TLM_SALES_LINK"
],
"selector": "#mainTBody table table tr:contains('SE/SD Name:') td:nth-of-type(4)",
"multiple": false,
"regex": "",
"delay": 0
},
{
"id": "DM_EMAIL",
"type": "SelectorText",
"parentSelectors": [
"TLM_SALES_LINK"
],
"selector": "#mainTBody table table tr:contains('DM Name:') td:nth-of-type(4)",
"multiple": false,
"regex": "",
"delay": 0
}
]
}