web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

N:N Relationship to Virtual Entity: OData query fails with "Invalid URI: The Uri string is too long."

(0) ShareShare
ReportReport
Posted on by 5

Odata queries from our power app fails when listing related virtual entities with the message: "code":"0x80040224","message":"Invalid URI: The Uri string is too long.". 

We are using the Microsoft.XRM.DataProvider.OData.V4.Plugins so the virtual entities can be resolved and shown in the power app.

We have a table in the power app where each row is related to N Virtual entities in another system and there is a form that lists the N virtual entities for a given row. It work fine when there are a few virtual entities but it quickly falls apart as the number grows.

It makes sense that the Uri would become too long if it puts all the Uids from the N:N relation in the query string to enable the other system to filter and page the virtual entities. All that is needed is to POST the query instead. The Odata endpoint that is queried for the virtual entities supports POST as well as GET but I don't see how I can get my power app to POST it instead.

I have the same question (0)
  • Esteban Coto Alfaro Profile Picture
    on at

    Hello, you can check the URI because URI has a max length. For large chunks of data is recommended to send it in JSON format.

    Thanks!

    Community Support Team - Esteban

    If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

  • Kristian Dahl Profile Picture
    5 on at

    Yeah, I know the url gets too long but I didn't write the OData data provider plugin which is maknig the query, I just wrote the service it is trying to send the query to. And the query will become massive, there is no way around that, so putting it in the url makes no sense. I just want the plugin to POST the query instead.

    I really don't want to have to write my own OData dataprovider plugin.

  • Tech full Profile Picture
    5 on at

    HI I have also same issue how can be convert into query string to json format

    $filter=StatusName eq 'In FIU L1 Review' and WhereIn(WorkflowItemId,57122,57123,57125,57126,57127,57128,57129,57130,57131,57132,57133,57134,57135,57136,57137,57139,57140,57141,57142,57143,57144,57145,57146,57147,57148,57149,57150,57151,57152,57153,57154,57160,57163,57164,57165,57166,57171,57172,57174,57175,57178,57179,57180,57182,57183,57184,57185,57186,57193,57194,57196,57197,57198,57199,57200,57201,57202,57203,57204,57205,57206,57207,57208,57209,57210,57211,57212,57213,57214,57215,57216,57217,57218,57219,57220,57222,57223,57224,57225,57226,57227,57228,57229,57230,57232,57233,57234,57235,57236,57237,57238,57239,57240,57241,57243,57244,57245,57246,57247,57248,57249,57250,57252,57253,57254,57255,57256,57257,57258,57259,57260,57261,57262,57263,57264,57266,57268,57270,57271,57273,57274,57275,57278,57279,57280,57281,57282,57283,57284,57285,57286,57287,57289,57291,57292,57293,57294,57295,57296,57309,57311,57312,57313,57314,57315,57319,57320,57321,57322,57323,57325,57326,57327,57329,57330,57332,57333,57334,57335,57336,57337,57338,57339,57340,57343,57344,57345,57346,57350,57351,57352,57353,57354,57366,57369,57370,57371,57374,57375,57376,57377,57379,57385,57386,57387,57388,57389,57390,57391,57392,57393,57394,57395,58394,58396,58397,58399,58400,58402,58403,58404,58405,58408,58409,58423,58424,58425,58445,58447,58473,58511,58521,58529,58536,58541,58542,58543,58544,58557,58558,58559,58560,58561,58562,58563,58564,58565,58566,58567,58568,58570,58571,58572,58573,58574,58575,58601,58602,58603,58604,58605,58606,58607,58616,58639,58642,58643,58644,58645,58646,58647,58648,58649,58654,58655,58662,58663,58668,58669,58670,58673,58674,58675,58677,58681,58682,58683,58687,58688,58690,58691,58794,58795,58796,58797,58798,58799,58800,58801,58802,58803,58804,58806,58807,58808,58809,58810,58832,58833,58834,58835,58836,58837,58838,58839,58840,58841,58865,58867,58868,58869,58870,58871,58872,58873,58874,58881,58882,58883,58884,58885,58886,58887,58888,58889,58890,58891,58892,58893,58894,58895,58896,58897,58898,58899,58900,58901,58902,58903,58904,58905,58906,58907,58908,58909,58910,58911,58912,58913,58914,58915,58916,58917,58918,58920,58921,58922,58923,58926,58927,58928,58929,58930,58931,58932,58933,58934,58935,58936,58937,58938,58939,58940,58960,58961,58962,58963,58964,58965,58966,58967,58968,58969,58970,58971,58972,58973,58974,58977,58978,58979,58980,58981,58982,58985,58986,58987,58988,58989,58990,58991,58992,58993,58994,58995,58996,58997,58998,58999,59000,59001,59002,59003,59005,59006,59090,59091,59092,59093,59145,59146,59147,59148,59149,59150,59151,59152,59153,59154,59155,59156,59157,59158,59160,59162,59163,59164,59165,59166,59167,59168,59169,59170,59171,59172,59173,59174,59175,59177,59178,59179,59180,59185,59186,59187,59188,59189,59190,59191,59192,59193,59194,59196,59197,59198,59199,59200,59201,59202,59203,59204,59205,59206,59207,59208,59209,59210,59211,59212,59213,59221,59222,59223,59224,59225,59226,59227,59228,59229,59230,59231,59232,59233,59234,59236,59237,59238,59239,59240,59159,60352,60353,60354,60355,60356,60357,60358,60359,60360,60361,60362,60363,60364,60365,60366,60367,60368,60369,60370,60371,60372,60373,60374,60375,60376,60377,60378,60379,60380,60381,60382,60383,60384,60385,60386,60387,60388,60389,60390,60391,60392,60393,60394,60395,60396,60397,60398,60399,60400,60401,60402,60403,60404,60405,60406,60407,60408,60409,60410,60411,60412,60413,60414,60415,60416,60417,60418,60419,60420,60421,60422,60423,60424,60425,60426,60427,60428,60429,60430,60431,60432,60433,60434,60435,60436,60437,60438,60439,60440,60441,60442,60443,60444,60445,60446,60447,60448,60449,60450,60451,60452,60453,60454,60455,60456,60457,60490,60491,60492,60493,60494,60495,60496,60497,60498,60499,60500,60501,60502,59235,62656,62657,62658,62659,62660,62661,62662,62663,62664,62665,62666,62667,62668,62669,62670,62671,62672,62673) and REVIEWOPEN() and WhereIn(WorkflowTypeId,10)&$top=50&$skip=0&$orderby=QueueDate

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 61

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 52 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans