Skip to content

JSON file output contains bogus entries - CAMS CAS #120

@ashokkjag

Description

@ashokkjag

I'm seeing random folio/amc where I have never invested showing up in the JSON output.

The CSV output is correct. I'm not sure how to share a sample CAS PDF here.

❯ casparser -o /tmp/out.csv /tmp/CAS.pdf
Enter PDF password:
Generating detailed CSV file...
File saved : /tmp/out.csv

❯ casparser -o /tmp/out.json /tmp/CAS.pdf
Enter PDF password:
Generating JSON file...
File saved : /tmp/out.json

❯ cut -d "," -f 1 /tmp/out.csv | sort | uniq
AXIS Mutual Fund
Aditya Birla Sun Life Mutual Fund
Capitalmind Mutual Fund
Franklin Templeton Mutual Fund
HDFC Mutual Fund
HSBC Mutual Fund
ICICI Prudential Mutual Fund
Nippon India Mutual Fund
PGIM INDIA MUTUAL FUND
PPFAS Mutual Fund
UTI Mutual Fund
amc

❯ wc -l /tmp/out.csv
282 /tmp/out.csv

❯ jq '.folios[] | .amc' /tmp/out.json | uniq
"Aditya Birla Sun Life Mutual Fund"
"AXIS Mutual Fund"
"Bandhan Mutual Fund"
"Capitalmind Mutual Fund"
"Franklin Templeton Mutual Fund"
"HDFC Mutual Fund"
"HSBC Mutual Fund"
"ICICI Prudential Mutual Fund"
"Nippon India Mutual Fund"
"PGIM INDIA MUTUAL FUND"
"PPFAS Mutual Fund"
"SBI Mutual Fund"
"UTI Mutual Fund"

❯ jq '.folios[] | .schemes[] | .transactions[] | .date' /tmp/out.json | wc -l
281

notice the additional Bandhan and SBI Mutual funds with random folio numbers but no transactions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions