Reltio Connect

 View Only
  • 1.  IDs for SQS Events

    Founding Member
    Posted 03-08-2023 09:48

    Hi All,

    Do we have a way to generate an ID for each SQS event? 



    ------------------------------
    Ashish Rawat
    Manager
    Fresh Gravity
    Bangalore
    ------------------------------


  • 2.  RE: IDs for SQS Events

    Reltio Employee
    Posted 03-09-2023 10:44

    I can't think of a way to do that.  What are you trying to do?



    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 3.  RE: IDs for SQS Events

    Reltio Employee
    Posted 03-10-2023 11:44

    Hi Ashish,

    For SQS messages, AWS creates a messageID for each message. will that help? It looks something like this - 

    Name: messageId,
    Value: 
    {
                Binary list values: null,
                Binary value: null,
                Data type: String,
                String list values: null,
                String value: b0379c7e-98cc-4ff0-b27e-b6d1505866ab
    }



    ------------------------------
    Ranadip Das
    ------------------------------



  • 4.  RE: IDs for SQS Events

    Founding Member
    Posted 03-10-2023 23:22

    Thanks Ranadip, Is there a way we can configure it in Reltio's provided SQS? 



    ------------------------------
    Ashish Rawat
    Manager
    Fresh Gravity
    Bangalore
    ------------------------------



  • 5.  RE: IDs for SQS Events

    Founding Member
    Posted 03-11-2023 00:26

    Hi Ashish, 

    I believe this will be present in all SQS messages irrespective of producer or owner.  



    ------------------------------
    Gowthamprabhu Sivaraj
    AstraZeneca
    ------------------------------



  • 6.  RE: IDs for SQS Events

    Reltio Employee
    Posted 03-11-2023 12:21

    Yes, the messageId would be present for all SQS messages regardless of the producer. It is something that AWS creates and would depend on the way you are consuming the messages. Below is a sample SQS message. The "Body" section would have the message that is created by Reltio. If you are just retrieving the body from the message, then you would not get the messageId, but if you retrieve the entire message, then you should see the messageId as well. 

    		{
    			"Attributes": [
    				{
    					"Name": "SenderId",
    					"Value": "xxxxxxxxxxxx"
    				},
    				{
    					"Name": "ApproximateFirstReceiveTimestamp",
    					"Value": "1678317892289"
    				},
    				{
    					"Name": "ApproximateReceiveCount",
    					"Value": "1"
    				},
    				{
    					"Name": "SentTimestamp",
    					"Value": "1678317890059"
    				},
    				{
    					"Name": "AWSTraceHeader",
    					"Value": "Root=1-291f38c4-b5fdc371e47d03bbc8d6b80f;Parent=57f8e5b93327a8f4;Sampled=1"
    				}
    			],
    			"Body": "xxxxxxxxxxxxxxxxxxxxxxx",
    			"MD5OfBody": "60eb157b95092f2d77de448184f20724",
    			"MD5OfMessageAttributes": "f1f9a5e20cfcd2df3ca942eb7d404747",
    			"MessageAttributes": [
    				{
    					"Name": "commitTime",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "1678317880679"
    					}
    				},
    				{
    					"Name": "contentType",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "application/json"
    					}
    				},
    				{
    					"Name": "eventType",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "ENTITY_CREATED"
    					}
    				},
    				{
    					"Name": "messageId",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "b0379c7e-98cc-4ff0-b27e-b6d1505866ab"
    					}
    				},
    				{
    					"Name": "objectVersion",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "1000000000"
    					}
    				},
    				{
    					"Name": "operationId",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "d32a75b8-3dd1-4546-bdf2-94b22d3a1ca5"
    					}
    				},
    				{
    					"Name": "sourceObjectUri",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "entities/xxxxxxxx"
    					}
    				},
    				{
    					"Name": "tenantId",
    					"Value": {
    						"BinaryListValues": null,
    						"BinaryValue": null,
    						"DataType": "String",
    						"StringListValues": null,
    						"StringValue": "xxxxxxxxxxxxx"
    					}
    				}
    			],
    			"MessageId": "53a09418-a10c-4cc7-ac7e-3a7473b87adc",
    			"ReceiptHandle": "AQEBDFXhvOz06e40Q9EX45Ne04whCSOHkeak1Bkny/GLmCGA0TflrDY7FgjBxDsC1Sb9o6VvG5LB/jXbgIdlY0hLAb3Ijt8uvKgcQWzd4t/tEDVa/AmlNQuZrXmpMaUCzAdofmvnqep60/8YChVR4EgrwyRPAefoEMCsTuJeCPID6JOt+W23UeEpX9YOyE07HCIrJ/Ct3ZXPyQkZtL1kM4JeXRRKH/BMUcrnHtTTLJzS/tN5rmFS3U/RPNxJderIrHqMcBIA+VArOZagShd5V8OinxtqYJtpnASAtOnL1cmKqPRyk1/9Tsa/Ltq8R1TEuGBXTzmaoffAOrf4DvZ9fgGQhcUys//6pSw3QPSwIXWa20Vanx3U4BSw9RsLB3FdZ0ijWUcRPIZEjQy4xfw/OdqLNQ=="
    		}
    	


    ------------------------------
    Ranadip Das
    ------------------------------



  • 7.  RE: IDs for SQS Events

    Founding Member
    Posted 03-13-2023 10:49

    Thanks guys, the information was useful.



    ------------------------------
    Ashish Rawat
    Manager
    Fresh Gravity
    Bangalore
    ------------------------------