Skip to content

bug: querying data through SQL doesn't work #172

Description

@honzakostejn

Problem

When querying data from tables, the call fails with duplicate header error. I suspect the issue is in tables where there is 5k+ records. Wasn't investigating properly.

Repro

dnx TALXIS.CLI -- environment data query sql "SELECT TOP 5 talxis_addressid FROM talxis_address" -p devbox-kos-pct24002-01
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
14:18:17+02:00 [INFO]  Resolved target environment 'https://devbox-kos-pct24002-01.crm4.dynamics.com' using profile 'devbox-kos-pct24002-01', connection 'devbox-kos-pct24002-01', credential 'jan.kostejn@thenetw.org' (source: CommandLine).
An item with the same key has already been added. Key: Cookie
14:18:19+02:00 [ERROR] Command failed: An item with the same key has already been added. Key: Cookie
14:18:19+02:00 [INFO]  If this is unexpected, report at https://github.com/TALXIS/tools-cli/issues
  Session: e77ec090-b8b5-40b4-a072-05f67ed4067c
  Operation: 40288463d8c5858e3ee44d13f0e512ba
  Logs: /tmp/nix-shell.xBpvLb/txc/logs/session-e77ec090-b8b5-40b4-a072-05f67ed4067c.jsonl

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions