Hi, is there a way to process (convert) response data in an incoming config before it is split up into entities by Alumio?
Hi @ben,
Could you clarify what kind of process you are referring to? Are you talking about mapping, or something else?
Hi Rian, of course.
I am using the Snowflake Subscriber to get data from Snowflake. In this case customers.
Snowflake returns the data like this:
{
"resultSetMetaData": {
"rowType": [
{
"name": "ID",
},
{
"name": "EMAIL",
},
{
"name": "FIRSTNAME",
},
{
"name": "LASTNAME",
}
]
},
"data": [
[
"123",
"[email protected]",
"John",
"Doe"
],
[
"124",
"[email protected]",
"Mary",
"Doe"
],
[
"125",
"[email protected]",
"Peter",
"Johansen"
],
]
}
So, the keys are in the “rowType” array, and the values in the “data” array.
I want Alumio to process the customers one per task obviously.
So basically I want to combine the keys and values to a customers array first:
{
"customers": [
{
"ID": "123",
"EMAIL": "[email protected]",
"FIRSTNAME": "John",
"LASTNAME": "Doe"
},
{
"ID": "124",
"EMAIL": "[email protected]",
"FIRSTNAME": "Mary",
"LASTNAME": "Doe"
},
{
"ID": "125",
"EMAIL": "[email protected]",
"FIRSTNAME": "Peter",
"LASTNAME": "Johansen"
}
]
}
so I can simply enter “customers” in the Pattern to items field:
Basically I need a “transform response before it is spit up into instances” transformer. Maybe Alumio has one already somewhere, but I can’t find it.