Forum Discussion

Rahul's avatar
Rahul
New Contributor III
4 years ago

How to get column names and corresponding column values

“Received,Carrier,Tracking number,Status,Locker Number,Delivered,Delivered to,Recipient,Recipient location,Package location,Sender,Comments,Arrived damaged,Modified By,Job ID Test,Bin,Department,PO N...
pipeline
JensDeveloper's avatar
JensDeveloper
Contributor II
3 years ago
Copy LinkReport

Hi @ptaylor,
Thank you for your input, unfortunately ,
I already tried this with only the api key and secret but that doesn’t work, also all possible mechanisms and both encrypted as base64 code. Because it works with the REST API endpoint but not with the ssl account and bootstrap server endpoint.

Regards

Jens

ptaylor's avatar
ptaylor
Employee
3 years ago
Copy LinkReport

Jens,

I just verified that our instructions work as described for Confluent Cloud accounts:

What do you mean that “it works with the REST API endpoint”? Our Kafka snaps do not work with the Confluent REST Proxy, which is a low-performance HTTP protocol adapter layer relative to the high-performance binary protocol used by the Kafka brokers. Our account requires the host:port value shown as the Bootstrap server in the Confluent Cloud Cluster settings:

Your account screenshot is showing several things misconfigured:

  • No keystore or truststore file is required.
  • The Security Protocol must be SASL_SSL, not SASL_PLAINTEXT.
  • The SASL Mechanism must be PLAIN (you have this part correct).
  • The SASL Username or Key and SASL Password or Key must be set to the Key and Secret values obtained when creating the API key in Confluent Kafka. No re-encoding of anything is necessary.
  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago
    Copy LinkReport

    @robin, would it be safe to assume that this will work for generating html files from XML generator snap?

    • robin's avatar
      robin
      Former Employee
      4 years ago
      Copy LinkReport

      Yes, though I would consider it “XHTML” (an old term)

      • darshthakkar's avatar
        darshthakkar
        Valued Contributor
        4 years ago
        Copy LinkReport

        Thanks @robin, I haven’t had a chance to test the solution you provided but I’m sure it would have worked.
        I went with a different route for my development so the concern I was having has been resolved.

        XML Generator does intake dynamic values if they have been binded properly prior to it (using Aggregate or Group By), the only challenge I found was ingesting native html tags because <a href ="$URL"> wasn’t generating the desired output as the tags gets converted to snapLogic’s predefined symbols like < = &lt;,so on and so forth. Check these links for detailed explanation on tags conversion:

        Link 1
        Link 2

        What I found and worked for me was defining the html format (if you’re trying to generate html files; could be any format you’re interested into) in the mapper itself/file writer and then let the format do its job.

        Thanking @robin for his suggestions, time and help on this. Signing off from this thread.