pushshift / api

Pushshift API
1.29k stars 107 forks source link

querying by link_id fails with a number_format_exception #137

Open UnironicHeyMoon opened 1 year ago

UnironicHeyMoon commented 1 year ago

Hello.

When I run "GET api.pushshift.io/reddit/comment/search/?link_id=10px1x6&subreddit=dataisbeautiful", I get this response.

{
    "data": [],
    "error": null,
    "errors": {
        "error": {
            "root_cause": [
                {
                    "type": "query_shard_exception",
                    "reason": "failed to create query: For input string: \"10px1x6\"",
                    "index_uuid": "htpvQm2RT4uCWzM53Q3zuw",
                    "index": "rc_2005-12"
                },
                <above object 200 more times>
            ],
            "type": "search_phase_execution_exception",
            "reason": "all shards failed",
            "phase": "query",
            "grouped": true,
            "failed_shards": [
                {
                    "shard": 0,
                    "index": "rc_2005-12",
                    "node": "r5briY5hS_mr4RzlALKdow",
                    "reason": {
                        "type": "query_shard_exception",
                        "reason": "failed to create query: For input string: \"10px1x6\"",
                        "index_uuid": "htpvQm2RT4uCWzM53Q3zuw",
                        "index": "rc_2005-12",
                        "caused_by": {
                            "type": "number_format_exception",
                            "reason": "For input string: \"10pv7qa\""
                        }
                    }
                },
                <above object 200 more times>
            ]
        },
        "status": 400
    }
}

It is clear to me that the issue is that the link_id field is being improperly cast to an int, because this works just fine: api.pushshift.io/reddit/comment/search/?link_id=100000&subreddit=trees