Query failed while parsing data for json column

[LalitLab]

Note: Requires GitHub plugin to reproduce the issue.

The below query failed for the commit 76ffc09

select
  sha,
  author_login,
  author_date, message
from
  github_commit
where
  repository_full_name = 'turbot/steampipe' and sha = '76ffc09a340612b2831efcbf3a8488b2f6360104';

It failed specifically while parsing commit field to jsonb.
{Name: "commit", Type: proto.ColumnType_JSON, Description: "Commit details."},

Steampipe query logs

2021-09-30 11:20:14.467 GMT [86758] ERROR:  invalid input syntax for type json
2021-09-30 11:20:14.467 GMT [86758] DETAIL:  Escape sequence "\'" is invalid.
2021-09-30 11:20:14.467 GMT [86758] CONTEXT:  JSON data, line 1: ...pe-postgre-fdw to v0.2.2 - fix JSON data with '\'...

Raw data for commit from API

{
  "sha": "76ffc09a340612b2831efcbf3a8488b2f6360104",
  "node_id": "MDY6Q29tbWl0MzMwNDA1MTg0Ojc2ZmZjMDlhMzQwNjEyYjI4MzFlZmNiZjNhODQ4OGIyZjYzNjAxMDQ=",
  "url": "https://api.github.com/repos/turbot/steampipe/git/commits/76ffc09a340612b2831efcbf3a8488b2f6360104",
  "html_url": "https://github.com/turbot/steampipe/commit/76ffc09a340612b2831efcbf3a8488b2f6360104",
  "author": {
    "name": "kai",
    "email": "[email protected]",
    "date": "2021-09-08T14:10:22Z"
  },
  "committer": {
    "name": "kai",
    "email": "[email protected]",
    "date": "2021-09-08T14:10:22Z"
  },
  "tree": {
    "sha": "d38ec7a3e6fc07129743aae158596cc0acb72796",
    "url": "https://api.github.com/repos/turbot/steampipe/git/trees/d38ec7a3e6fc07129743aae158596cc0acb72796"
  },
  "message": "Update steampipe-postgre-fdw to v0.2.2 - fix JSON data with '\\u0000' resulting in Postgres error \"unsupported Unicode escape sequence\".",
  "parents": [
    {
      "sha": "199206089d1a1cff81c34c49bb4d1faa3cc85e41",
      "url": "https://api.github.com/repos/turbot/steampipe/git/commits/199206089d1a1cff81c34c49bb4d1faa3cc85e41",
      "html_url": "https://github.com/turbot/steampipe/commit/199206089d1a1cff81c34c49bb4d1faa3cc85e41"
    }
  ],
  "verification": {
    "verified": false,
    "reason": "unsigned",
    "signature": null,
    "payload": null
  }
}

[LalitLab]

turbot/steampipe-plugin-github#65 (comment)

[judell]

Thanks for the fix!