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

(0) Share

Report

Posted on by Kristian Dahl

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.

All responses (3)

Answers (0)

Tech full 5 on at

Like (0)

Report

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

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
Kristian Dahl 5 on at

Like (0)

Report

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

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.
Esteban Coto Alfaro on at

Like (0)

Report

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

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.

Community site session details

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

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Kudos to the April Top 10 Community Stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Kudos to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates