Unable to retrieve metadata fields in tMicrosoftCrmInput

[DaniZ]

Hi,

I'm trying to retrieve metadata fields (e.g. incidentstagecode_FormattedValue) using the tMicrosoftCrmInput component (Talend 8).

I've already added an HTTP header in order to allow for such retrieval (Prefer : odata.include-annotations=OData.Community.Display.V1.FormattedValue),
but the problem is that I would need to reference these fields in the following manner:
[attribute_name]@OData.Community.Display.V1.FormattedValue

Now the schema editor obviously doesn't allow the @ in the column name, and there seems to be no other way to let the component know that I want to retrieve a metadata field like that.

So am I missing something here or does this need to go to R&D?

The possible solutions would be to either include ALL fields (including metadata) in the drop down schema option and then let the user remove whatever they don't need, or create some sort of inner mapping option (like in XML components), that would be able to map field references containing @ to allowed column names.

Should I open this as a support case, or is there a solution I am unaware of?

[Mohammed_Messaoudi]

Hello,

Instead of relying on the schema in tMicrosoftCrmInput, you can try the following suggestion:

1. Configure the component to return the raw JSON (or use a REST call via tRestClient).
2. Pass the response to tExtractJSONFields.
3. Manually extract fields using JSONPath, 

[DaniZ]

Thanks for the suggestion - but what would I need to define in the schema of tMicrosoftCrmInput in order to get the full JSON output? Is there such a specific column name that will give me this output?

I am aware of the RestClient/HttpClient solution, but I would prefer to avoid the extra configuration complications.

I feel that the dedicated component should be able to provide a solution for something which is surely a common requirement for those using it.

[DaniZ · Accepted solution]

I ended up submitting an Ideation request to include annotation retrieval functionality in this component. Hopefully it gets picked up...