get data from ODATA connector with specific columns

[Mornagli]

Hello im trying to get data from ODATA connector and i want to reduce the amount of data to be transsfered.

I been able to get specific columns fro mthe main tables, but i have some subtables that i do not want to get all their columns, who can i do it? here is my requests:

1. Main table with specicfic columns :

OData.Feed(https:/MY_URL.../MAIN_TABLE?$select=COL_A,COL_B,COL_SUBTABLE) - now i want to get from COL_SUBTABLE- only specific columns, is it possible? I already tried with $expand, (and from a script i manage to get just specifc columns from the subtables) but i think that with ODATA connector, the SUBTABLE is not recognized as table but as column....

Any help will be great, thank you.

[v-yalanwu-msft]

Hi， @Mornagli ；

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi， @Mornagli ；

You could try it.

The way around this is to modify the URL you are using for the OData feed.  

After /_vti_bin/ListData.svc you should add the specific table and the select all query

ex. https://siteurl.com/projectserver/db/_vti_bin/ListData.svc/tablename?$select=*

Or Define the OData query as needed, instead of navigating from the top of the orgnisation:

= OData.Feed("https://org.api.crm.dynamics.com/api/data/v9.1/accounts?$select=accountid,name", null, [Implementation="2.0"])

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.