Skip to main content
All CollectionsData Management
Troubleshooting "I was expecting more rows than I got"
Troubleshooting "I was expecting more rows than I got"
Written by Öykü Eda Aydın
Updated over a week ago


When working with data extraction tools, you may occasionally encounter situations where you expect to receive more rows in the extracted data than you actually get. This guide will help you understand the possible reasons for this issue, provide troubleshooting steps to identify the problem and guide you on how to create a support ticket with WebAutomation to resolve the issue.

Possible Reasons for Fewer Rows

There are several reasons why you might receive fewer rows than expected:

  1. Changes in the website structure: The structure of the target website may have changed, causing WebAutomation's extraction tool to fail in fetching the data accurately. Websites often update their layout, design, or data structure, which might affect the extraction process.

  2. Pagination issues: WebAutomation's extraction tool might not be properly navigating through all pages of the target website, resulting in incomplete data. Pagination issues can occur if the tool isn't configured correctly to follow links to subsequent pages or if the website has implemented a non-standard pagination method.

  3. Data extraction limits: WebAutomation may have limits on the number of rows that can be extracted in a single session, causing you to receive fewer rows than expected. These limits could be imposed by the tool itself or set by the user to prevent overloading the system or the target website.

  4. Website restrictions: The target website might have implemented restrictions or anti-bot measures that prevent WebAutomation's extraction tool from accessing the data. Websites might use techniques like CAPTCHAs, IP blocking, or cookie tracking to deter automated data extraction.

Troubleshooting Steps

To identify the issue of receiving fewer rows than expected with WebAutomation, follow these troubleshooting steps:

Step 1: Verify the Website Structure

Visit the target website and verify if the structure has changed since the last time you configured your WebAutomation extractor. If there have been changes, this could be the reason for receiving fewer rows than expected.

Step 2: Check for Pagination Issues

Ensure that your WebAutomation extractor is navigating through all pages of the target website. If you suspect pagination issues, this could be contributing to incomplete data extraction.

Step 3: Review Your Account Limits

Log in to your WebAutomation account and verify if you have reached any credit limits imposed by the service. Reaching these limits could result in receiving fewer rows than expected.

Step 4: Create a Support Ticket with web automation

If you cannot resolve the issue on your own or suspect that the problem might require technical assistance, create a support ticket with WebAutomation. Provide a detailed description of the issue, including the website URL, your extraction settings, and any observations you made while troubleshooting. This information will help the WebAutomation support team understand the problem and provide an appropriate solution. You can check the guide on how to raise a PDE ticket.

By following this troubleshooting guide, you should be able to identify the issue causing you to receive fewer rows than expected in your data extraction process with WebAutomation. If you cannot resolve the issue yourself, creating a support ticket with WebAutomation will ensure that the problem is addressed promptly and professionally.

Did this answer your question?