topic Re: Unable to retrieve metadata fields in tMicrosoftCrmInput in Talend Studio

Unable to retrieve metadata fields in tMicrosoftCrmInput

DaniZ — Wed, 15 Apr 2026 12:04:06 GMT

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?

Re: Unable to retrieve metadata fields in tMicrosoftCrmInput

Mohammed_Messaoudi — Wed, 15 Apr 2026 15:22:33 GMT

Hello,

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

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

Re: Unable to retrieve metadata fields in tMicrosoftCrmInput

DaniZ — Wed, 15 Apr 2026 15:39:10 GMT

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.

Re: Unable to retrieve metadata fields in tMicrosoftCrmInput

DaniZ — Tue, 21 Apr 2026 06:38:06 GMT

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