Business List from Location Search - Confirm & Copy Final Agent Code

Describe

Describe your task

Refine

Refine the plan

SubAgents

Review all agents

Deploy

Deploy your agent

Review Final Agent Copy

Expand

[
  {
    "taskID": 190,
    "semanticTitleOfTask": "Format Comprehensive Search Query String for Oracle",
    "taskDescription": "This task takes the user’s specified business type (VARIABLE1) and location (VARIABLE2) to construct a concise, accurate query aimed at Oracle’s web search. By focusing on local business directories and official listings, it ensures maximum coverage of complete contact information for the targeted area.",
    "inputDescription": "This task requires two inputs: VARIABLE1 (the category of business or service) and VARIABLE2 (the city, region, or zip code). Both inputs are combined to form a well-structured phrase that guides the subsequent Oracle query toward relevant local businesses with complete contact details.",
    "inputRequired": ["VARIABLE1", "VARIABLE2"],
    "outputDescription": "A standardized search query string optimized for Oracle’s web search. Its wording and structure prioritize finding detailed, up-to-date business listings, ensuring relevant and accurate results are returned in the next task for further processing.",
    "outputName": "formatted_query_string",
    "promptInstruction": "Using the provided business type (VARIABLE1) and location (VARIABLE2), create a comprehensive search query that will effectively find business listings. The query should be formatted to discover business names, addresses, phone numbers, ZIP codes, and websites. Format the query to maximize relevant results while filtering out irrelevant listings. The query should be clear and direct, focusing on local business directories and official business listings."
  },
  {
    "taskID": 224,
    "semanticTitleOfTask": "Search the Web for Business Listings via Oracle",
    "taskDescription": "This task uses Oracle’s web search functionality to locate businesses matching the specified type and location. It retrieves raw, unstructured text that may include names, addresses, phone numbers, ZIP codes, and websites. The returned data forms the basis for subsequent parsing and structuring steps.",
    "inputDescription": "This task accepts the previously formatted query string (formatted_query_string). Oracle then uses this input to search reliable sources and directories for businesses, aiming to retrieve as many complete contact details as possible.",
    "inputRequired": ["formatted_query_string"],
    "outputDescription": "The output is a block of unstructured text containing a list of businesses located in the specified area. Each record may include the business name, address, phone number, ZIP code, and website if available. This raw data is ready for further parsing.",
    "outputName": "raw_business_search_results",
    "promptInstruction": "Search for businesses of the specified type in the given location. Return comprehensive details including business names, complete street addresses, phone numbers, ZIP codes, and website URLs when available. Focus on authoritative business directories and official company listings. Include only currently active businesses and prioritize complete contact information. Provide the results as plain text, including all available details for each business found."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Initial Business Data Cleanup and Segmentation",
    "taskDescription": "This task processes raw business search results to remove irrelevant content and organize each business listing (including name, contact, location) into separate blocks or line items. The output is a cleaned list of distinct business entries.",
    "inputDescription": "The inputs required are the unstructured text containing raw business search results, as well as instructions for how to remove irrelevant text, segment each business, and keep only factual business details to produce a cleaned list.",
    "inputRequired": ["raw_business_search_results"],
    "outputDescription": "The output is a cleaned version of the original text with irrelevant details removed, duplicates removed, and each business carefully separated into its own line or block, ready for field extraction.",
    "outputName": "cleaned_block_based_text",
    "promptInstruction": "Process the following raw business search results. For each business listing found:\n1. Remove any advertising or irrelevant content\n2. Create a separate block or line item for each unique business\n3. Maintain only factual business information (name, contact details, location)\n4. Remove duplicate entries\n5. Ensure each business block is clearly separated\n\nReturn the cleaned text with one business per line or block."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Business Field Extraction and Structured Formatting",
    "taskDescription": "This task processes the cleaned business blocks to parse out structured fields: Name, Street Address, City, ZIP Code, Phone Number, and Website URL. Each listing is formatted in a labeled structure for easy reading. If any field is unavailable, it is left blank.",
    "inputDescription": "The input is the cleaned block-based text from the previous step, along with instructions to parse each block for the required fields. This text is expected to contain each business listing as a discrete block or line.",
    "inputRequired": ["cleaned_block_based_text"],
    "outputDescription": "The output is a textual list with each business entry on a new line, containing the fields in curly braces with consistent labeling: Name, Address, City, ZIP, Phone, Website. If a field is missing, it remains blank but is included. This final data is ready for further formatting or CSV conversion.",
    "outputName": "extracted_business_details",
    "promptInstruction": "For each business block in the text, extract and format the following fields:\n1. Business Name\n2. Street Address\n3. City\n4. ZIP Code\n5. Phone Number\n6. Website URL (if available)\n\nFormat each business entry as follows:\n{Name: Business Name, Address: Street Address, City: City Name, ZIP: ZIP Code, Phone: Phone Number, Website: Website URL}\n\nIf any field is not found, leave it blank but maintain the field label.\nEnsure each business entry is on its own line.\nRemove any entries that don't have at least a business name and either a phone number or address."
  },
  {
    "taskID": 1,
    "semanticTitleOfTask": "Rewrite extracted business details into structured format",
    "taskDescription": "This task uses skill #190 to transform the extracted business details into a consistent, line-by-line comma-separated format. It ensures the data is placed in the exact order needed for subsequent CSV generation.",
    "inputDescription": "Loosely structured text containing business name, address, city, ZIP, phone, and website information. Sourced from the extracted_business_details token.",
    "inputRequired": ["extracted_business_details"],
    "outputDescription": "A single text block containing each business on its own line. Each line has: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL, comma-separated.",
    "outputName": "structured_business_data",
    "promptInstruction": "For each business entry in the input text, extract and reorganize the information into a standardized format. Each business should be on a new line. Fields must be arranged in this exact order: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL. Use commas to separate each field. If any field is missing, leave it blank but maintain the comma. Remove extra spaces or characters within a field. If a field contains a comma, enclose it in double quotes. Website URLs should exclude 'http://' or 'https://'. Phone numbers should be in (XXX)XXX-XXXX format."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Convert Structured Business Data to CSV Format",
    "taskDescription": "Using skill #190, this task transforms line-by-line structured business data into a CSV with the specified headers, ensuring each field is properly separated by commas and line breaks, so it can be opened in Excel without errors.",
    "inputDescription": "This task takes the structured_business_data token, which is text containing line-by-line business records with consistent field order, along with CSV formatting rules and a header row specifying the column labels. The data includes city, business name, phone number, street address, ZIP, and website URL.",
    "inputRequired": ["structured_business_data"],
    "outputDescription": "The output is a single CSV text string named csv_file_data, containing a header row followed by rows of business information. Each row has fields separated by commas, with Windows-style line endings, and can be saved as CrescentTechnical_Business_Search.csv.",
    "outputName": "csv_file_data",
    "promptInstruction": "You are tasked with converting structured business data into a proper CSV format. First, add this header row exactly as shown: “City,Business Name,Phone Number,Street Address,ZIP Code,Website URL”. Then, take each line of the structured business data and format it as a CSV row. Ensure each field is separated by commas, that any commas within field values are escaped, and that each record starts on a new line. Use Windows-style line endings and do not add extra commentary or markup."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Format CSV Data with User Instructions",
    "taskDescription": "This task takes raw CSV data and wraps it in user-friendly instructions, creating a final text output that includes both Crescent Technical branding and guidance on how to save/use the CSV file in Excel.",
    "inputDescription": "Requires the plain-text CSV data (csv_file_data) plus the company name (VARIABLE3). The CSV data includes columns such as City, Business Name, Phone Number, Street Address, ZIP Code, and Website URL.",
    "inputRequired": ["csv_file_data", "VARIABLE3"],
    "outputDescription": "A single text block labeled final_csv_export. It contains a header, instructions for saving/opening the CSV, and the full CSV data so the user can copy/paste or open it in Excel.",
    "outputName": "final_csv_export",
    "promptInstruction": "You are creating a user-friendly output for Crescent Technical's business search results. Take the provided CSV data and create a formatted text output that includes:\n\n1. A header with \"Crescent Technical Business Search Results\"\n2. Clear, numbered instructions for the user explaining how to copy the CSV data, save it as a .csv file, and open it in Excel\n3. A clear separator line indicating where the CSV data begins\n4. The complete CSV data with headers and all rows\n\nThe final output should follow this general structure but using the actual CSV data provided:\n\n=== Crescent Technical Business Search Results ===\n\nTo use these results:\n1. Copy all the text below this line\n2. Paste into a new text file\n3. Save with the extension .csv (e.g., \"CrescentTechnical_Business_Search.csv\")\n4. Open in Excel\n\n----- CSV DATA BELOW THIS LINE -----\n[CSV data goes here]"
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Initial Data Validation and Deduplication of Business Listings CSV",
    "taskDescription": "This task cleans the raw CSV data by removing any rows missing a required field (business name or phone number) and eliminating duplicates where the name, phone number, and street address match. It preserves CSV formatting and keeps the original column order.",
    "inputDescription": "Requires the raw CSV text of business listings. The CSV must contain columns in the sequence: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL. The task also needs validation rules for what constitutes a complete record and deduplication criteria.",
    "inputRequired": ["raw_csv_text"],
    "outputDescription": "Returns a CSV string with invalid and duplicate rows removed. Each remaining row is valid and unique according to the specified criteria.",
    "outputName": "validated_csv_data",
    "promptInstruction": "You are a data validation specialist. Your task is to clean the following CSV business listing data. Follow these steps:\n1. Remove any rows missing either a business name or phone number\n2. Remove duplicate entries where the Business Name, Phone Number, AND Street Address are identical\n3. Preserve the CSV format with commas between fields\n4. Keep original column order: City, Business Name, Phone Number, Street Address, ZIP Code, Website URL\nReturn only the cleaned CSV text with no additional commentary."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Data Format Normalization for Business Listings CSV",
    "taskDescription": "This task standardizes the formatting of the CSV data after validation. It updates phone numbers to a uniform format, converts city names to title case, trims whitespace, and applies consistent formats for addresses, ZIP codes, and website URLs while preserving CSV structure.",
    "inputDescription": "Requires the validated_csv_data from the previous step and a set of formatting rules specifying how to normalize the data (phone format, city case, address format, ZIP code consistency, website URL standardization).",
    "inputRequired": ["validated_csv_data"],
    "outputDescription": "Returns a CSV text string where phone numbers, city names, addresses, ZIP codes, and website URLs are consistently formatted, and extraneous spaces removed.",
    "outputName": "normalized_csv_data",
    "promptInstruction": "You are a data formatting specialist. Normalize the following CSV business data according to these rules:\n1. Phone numbers: Format as (XXX) XXX-XXXX\n2. City names: Convert to Title Case (e.g., \"dallas\" → \"Dallas\")\n3. Business names: Remove extra spaces, preserve original capitalization\n4. Street addresses: Title Case, remove extra spaces\n5. ZIP codes: Ensure 5-digit format\n6. Website URLs: Remove trailing slashes, ensure starts with http:// or https://\n7. Trim all whitespace from start/end of each field\nReturn only the normalized CSV text with no additional commentary."
  },
  {
    "taskID": 190,
    "semanticTitleOfTask": "Final CSV Structure Generation for Business Listings",
    "taskDescription": "This task ensures the final CSV is properly structured for Excel import. It adds a header row, maintains exactly six fields per row, escapes any commas within fields, removes empty rows, and outputs a clean CSV with newlines at the end of each record.",
    "inputDescription": "Requires the normalized_csv_data from the previous step, the desired column order, and specifications on how to properly escape and format the CSV rows (including the header).",
    "inputRequired": ["normalized_csv_data"],
    "outputDescription": "Returns a final CSV string ready for Excel import, with a header row, standardized column order, and properly formatted rows containing six fields each.",
    "outputName": "final_csv_output",
    "promptInstruction": "You are a CSV formatting specialist. Take the following business listing data and ensure it meets these specifications:\n1. First row must be header: City,Business Name,Phone Number,Street Address,ZIP Code,Website URL\n2. Each subsequent row must have exactly 6 fields (empty fields shown as blank but with comma)\n3. Properly escape any commas within fields using double quotes\n4. Each record must end with a newline character\n5. Remove any empty rows\nReturn only the final CSV text with no additional commentary."
  }
]

Happy? Now Copy-Paste To Proceed...

BACK TO SUBAGENTS

COPY TO CLIPBOARD