Forum Discussion

bubba's avatar
bubba
New Contributor
4 years ago

Questions on using the SQL Server – Merge snap, where is WHEN MATCHED logic?

Hello, I’m a new user to Snaplogic, so go easy. 🙂 My question is on using the “SQL Server – Merge” snap: I’ve created a pipeline to import from a sftp csv-formatted source to merge (update or in...
Emilda's avatar
Emilda
New Contributor
2 years ago
Copy LinkReport

Have anyone tried consuming messages from Confluent Kafka topic using Rest Get in Snaplogic? i only get the metadata but not the key , value pair of data from the Topic. I see few posts in Kafka end saying we can not consume messages from a topic using Rest API. Is there a way?

  • Igor_Bozhinovsk's avatar
    Igor_Bozhinovsk
    New Contributor III
    3 years ago
    Copy LinkReport

    Thanks Alchemiz , the array is now spliited in two. One array with 100 elements and the other with the remaining elements.

    This is the current output :

    "ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
  [
    {
      "SerialNo": "123"
    },
	{ "SerialNo":"456"
    }
  ],
  [
	{
	  "SerialNo": "101"
	},
	{
	  "SerialNo": "102"
	}
  ]
 ]

    I was wondering if something like this output is possible :

    "ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
  [
    {
      "SerialNo": "123"
    },
	{ 
	  "SerialNo":"456"
    }
  ]
"ShipmentCreateDate": "01/01/2023",
"ShipmentID": "1",
"SerialNumbers": [
  [
	{
	  "SerialNo": "101"
	},
	{
	  "SerialNo": "102"
	}
  ]
 ]

    Where the first output would be the array with the 100 elements and the remaining fields that are not part of the array and the second output would be the array with the remaining elements and the fields that are not part of the array.

    Regards,
    Igor