# API Query not pulling columns with '@' symbol **URL:** \ **Category:** Matillion ETL\ **Created:** [April 18, 2023, 2:44am UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142 "2023-04-18T02:44:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![SB699925](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/sb699925/32/1180_2.png) [@SB699925](https://matillioncommunity.discourse.group/u/SB699925)\ **Post date:** [April 18, 2023, 2:44am UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142/1 "2023-04-18T02:44:43Z")
I have written a custom Dynamics 365 connector. Microsoft Dynamics 365 API returns some fields in this format: statecode@OData.Community.Display.V1.FormattedValue However when I include those fields in the API Query generator they are dropped in the final config. If I add them back in manually via Advanced mode, they are not being populated. ![0694G00000RqZkcQAF_0D54G00009GQYQDSA5](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/315df0c21ba619a8c14462cfcdf19a8275192e9b.png) Is there an issue with Matillion's implementation of CData or are '@' symbols not allowed in CData config? I couldn't find a reference to this in the CData specs: https://cdn.cdata.com/help/DWE/odbc/default.htm Any thoughts would be appreciated! Steve ---
**Author:** ![SB699925](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/sb699925/32/1180_2.png) [@SB699925](https://matillioncommunity.discourse.group/u/SB699925)\ **Post date:** [April 18, 2023, 6:26am UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142/2 "2023-04-18T06:26:02Z")
**\ I really wish Matillion forum allowed me to edit my posts!! \**       Here is an example of the RESPONSE from Dynamics 365 with the fields that are giving a problem to the API Query component: ![0694G00000RqaTNQAZ_0D74G000008ynA0SAI](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/ab856d6042a28fdaeb67655c7065fcf809012f26.png) The API Query component will not return these fields no matter what I’ve tried in the CData config… 😥 ---
**Author:** ![BenSmilesMatillionProductOwner](https://avatars.discourse-cdn.com/v4/letter/b/ba9def/32.png) [@BenSmilesMatillionProductOwner](https://matillioncommunity.discourse.group/u/BenSmilesMatillionProductOwner)\ **Post date:** [April 19, 2023, 7:53am UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142/3 "2023-04-19T07:53:33Z")
Hello SB699925   Firstly, the obvious questions: 1. Have you tried using our Manage _Extract_ API tool or our new Custom Connector tool? They extract the full JSON payload and aren't too bother by what it contains (parameter-wise). These tools are not built using CDATA, so it would also rule out any CDATA limitations, if there are any. 2. Have you tried using our ODATA Query connector, because this is clearly one of Microsoft's ODATA sources? The link to CDATA documentation you provided refers to the ODBC driver for REST, where API Query uses the JDBC driver for REST.   Regards Ben Smiles Matillion Product Team ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [April 19, 2023, 8:07am UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142/4 "2023-04-19T08:07:15Z")
Thank you [@BenSmilesMatillionProductOwner](https://matillioncommunity.discourse.group/u/BenSmilesMatillionProductOwner)​ that is brilliant, I hope this has helped [@SB699925](https://matillioncommunity.discourse.group/u/SB699925)​ please do let me know if you need anything else. In the meantime here is the support documentation for [Manage Extract API](https://documentation.matillion.com/docs/1959484) & [ODATA Query Connector](https://documentation.matillion.com/docs/2503812) these should assist in resolving the issue you have been met with. Thanks and have a great day! Joe ---
**Author:** ![SB699925](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/sb699925/32/1180_2.png) [@SB699925](https://matillioncommunity.discourse.group/u/SB699925)\ **Post date:** [April 19, 2023, 11:00pm UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142/5 "2023-04-19T23:00:50Z")
Hey Ben   Cheers for that answer, much appreciated! Turns out we are still running v1.61.6 (although I swear we upgraded to 1.62 last year). Anyhow that's on us. I'm pushing for an upgrade to 1.69 so hopefully that will happen soon!   We haven't used the API Extract since the API Query has just felt more flexible. I'll dust that off and have a look. I didn't realise there was an OData Query connector, I'll have a look at that also!   Thanks so much. ---
**Author:** ![BenSmilesMatillionProductOwner](https://avatars.discourse-cdn.com/v4/letter/b/ba9def/32.png) [@BenSmilesMatillionProductOwner](https://matillioncommunity.discourse.group/u/BenSmilesMatillionProductOwner)\ **Post date:** [April 20, 2023, 8:26am UTC](https://matillioncommunity.discourse.group/t/api-query-not-pulling-columns-with-symbol/2142/6 "2023-04-20T08:26:09Z")
Hello SB699925   May I recommend waiting for 1.70. It lands this week, I believe.   Regards Ben Smiles Matillion Product Team