In our company we have a Talend MDM Enterprise Edition server.
From the homepage of the TAC, I can see version is: 7.1.1.20181026_1147-
I'm in charge of querying data from this system. Disclaimer: I'm not part of our team working with the Talend server.
So I use the MDM Query Language as described in this online doc: https://help.talend.com/reader/OExHeKAk2NLlFKnNAXdI1A/ef~ulFtrHdc5ut5XIpp5IA
When I query like this:
{
"select": {
"from": [
"SomeType"
]
}
}
I get something like this:
[
{
"sometype": {
"idsometype": "1",
"labelsometype": "Label # 1"
}
},
{
"sometype": {
"idsometype": "2",
"labelsometype": "Label # 2"
}
}
]
I saw there is a way to alias fields, e.g.
{
"select": {
"from": [
"SomeType"
],
"fields": [
{
"alias": [
{
"name": "id"
},
{
"field": "SomeType/IdSomeType"
}
]
},
{
"alias": [
{
"name": "label"
},
{
"field": "SomeType/LabelSomeType"
}
]
}
]
}
}
but then I get this:
[
{
"$explicitprojection$": {
"id": "1",
"label": "Label # 1"
}
},
{
"$explicitprojection$": {
"id": "2",
"label": "Label # 2"
}
}
]
HOW do I alias the "$explicitprojection$"???