Historical Financial Data Extraction and Validation

I need a reliable solution to extract historical financial data from the Intrinio API using the following endpoint: https://api-v2.intrinio.com/companies/identifier/historical_data/tag Check API docs: https://intrinio.com/docs Requirements: Use the Excel file containing company tickers/identifiers and data tags as input. Retrieve the corresponding historical data for each ticker and tag combination. Ensure the data is accurate, complete, and sourced directly from the API. Eliminate duplicate records while preserving all valid historical observations. Maintain correct ticker, tag, date, and value mappings. Handle API errors, missing data, pagination, and rate limits appropriately. Export the results into a clean, structured Excel or CSV file. Include validation checks to ensure data integrity and avoid duplicate or incorrectly mapped records. Deliverables: Complete, working code and any required configuration instructions. A consolidated output file containing the extracted and validated data. A brief explanation of the extraction process and validation methods. Success Criteria: The final dataset must accurately reflect the source API, contain no unintended duplicate records, and be reproducible for future runs.