XML Reader does not work properly

[AashishMTech]

Issue Description

• Description of the issue: getting error while connecting to sftp ssh: handshake failed: ssh: no common algorithm for key exchange; client offered: [curve25519-sha256 [email protected] ecdh-sha2-nistp256 ecdh-sha2-nistp384 ecdh-sha2-nistp521 diffie-hellman-group14-sha256 diffie-hellman-group14-sha1 ext-info-c [email protected]], server offered: [diffie-hellman-group-exchange-sha256

• Sling version (sling --version): 1.2.14

• Operating System (linux, mac, windows): linux

• Replication Configuration:

# replication.yaml

source: MY_SFTP
target: SNOWFLAKE

defaults:
  mode: truncate
  source_options:
    format: xml


streams:
  
  "sftp://host/IN/contract.xml":
    object: 'app_{USER_NAME}'
    single: true


 
env:
  SAMPLE_SIZE: 2000 # increase the sample size to infer types (default=900).
  SLING_STREAM_URL_COLUMN: true # adds a _sling_stream_url column with file path
  SLING_LOADED_AT_COLUMN: timestamp
  USER_NAME: '${USER_NAME}' 
  
  ...

• Log Output (please run command with -d):

Paste log here.
ssh: handshake failed: ssh: no common algorithm for key exchange; client offered: [curve25519-sha256 [email protected] ecdh-sha2-nistp256 ecdh-sha2-nistp384 ecdh-sha2-nistp521 diffie-hellman-group14-sha256 diffie-hellman-group14-sha1 ext-info-c [email protected]], server offered: [diffie-hellman-group-exchange-sha256

[flarco]

can you try latest dev build?

https://f.slingdata.io/dev/latest/sling_linux_amd64.tar.gz https://f.slingdata.io/dev/latest/sling_darwin_arm64.tar.gz

[AashishMTech]

This works, i am able to connect.

[AashishMTech]

Auth works however, reading the xml files is giving below error now.

~ dataflow error while waiting for ready state ~ error in getting rows unhandled JSON interface type: <nil>

[flarco]

Added. Closing.