OData string error and problem with date formatsOData “where ID in list” queryWebAPI OData DateTime errorodata error - operator with incompatible types was detectedA binary operator with incompatible types was detected. Found operand types 'Edm.Guid' and 'Edm.String' for operator kind 'Equal'. OData 2.2How to Find all data of the day by the WCF Odata filterOData filter options fail when Uri has escaped ampersandFormat of an ODATA filter specifying an enumWhy is this URI producing a runtime error in the OData service?Excel/PowerBI OData import gives internal server error 500OData - query is fine in Chrome, 400 calling with Java
How to get a character's limb regrown at 3rd level?
Preferred word for "preferred", "target", "chosen" in end user support documentation
How is this practical and very old scene shot?
How do we separate rules of logic from non-logical constraints?
Prime parity peregrination
Is Cyclic Ether oxidised by periodic acid
13th chords on guitar
Most elegant way to write a one-shot 'if'
Why is Japan trying to have a better relationship with Iran?
Adjective for 'made of pus' or 'corrupted by pus' or something of something of pus
Using “ser” without "un/una"?
Company threatening to call my current job after I declined their offer
What's the safest way to inform a new user of their password on an invite-only website?
The warming up game
My colleague is constantly blaming me for his errors
Do home values typically rise and fall at a consistent percent?
Movie with Zoltar in a trailer park named Paradise and a boy playing a video game then being recruited by aliens to fight in space
How to properly say asset/assets in German
How to securely dispose of a smartphone?
Can I travel from Germany to England alone as an unaccompanied minor?
Why did NASA wet the road in front of the Space Shuttle crawler?
Are all commands with an optional argument fragile?
Have any large aeroplanes been landed - safely and without damage - in locations that they could not be flown away from?
Does a Hand Crossbow with the Repeating Shot Infusion still require a Free Hand to use?
OData string error and problem with date formats
OData “where ID in list” queryWebAPI OData DateTime errorodata error - operator with incompatible types was detectedA binary operator with incompatible types was detected. Found operand types 'Edm.Guid' and 'Edm.String' for operator kind 'Equal'. OData 2.2How to Find all data of the day by the WCF Odata filterOData filter options fail when Uri has escaped ampersandFormat of an ODATA filter specifying an enumWhy is this URI producing a runtime error in the OData service?Excel/PowerBI OData import gives internal server error 500OData - query is fine in Chrome, 400 calling with Java
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I try to get data to excel with OData. When I use link below it works fine:
http://xts/odata/AuditAggregationOdata
or
http://xts/odata/AuditAggregationOdata/?$filter=(ObjectId%20eq%2041143%20)
But when I try to use some date range or funcion with date it does not work. I try to write everything but without right result:
1.
http://xts/odata/AuditAggregationOdata/?$filter=year(FirstRead)%20eq%202016
Error message:
Unable to connect
We encountered an error while trying to connect
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)"
Or this one
2.
http://xts/odata/AuditAggregationOdata/?$filter=(FirstRead%20gt%20datetime%272019-01-01T00:00:00Z%27%20and%20FirstRead%20lt%20datetime%272019-01-03T00:00:00Z%27)
Error message:
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)"
Note:
Property Name="FirstRead" Type="Edm.DateTimeOffset"/
Thank you
filter connection odata
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
add a comment |
I try to get data to excel with OData. When I use link below it works fine:
http://xts/odata/AuditAggregationOdata
or
http://xts/odata/AuditAggregationOdata/?$filter=(ObjectId%20eq%2041143%20)
But when I try to use some date range or funcion with date it does not work. I try to write everything but without right result:
1.
http://xts/odata/AuditAggregationOdata/?$filter=year(FirstRead)%20eq%202016
Error message:
Unable to connect
We encountered an error while trying to connect
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)"
Or this one
2.
http://xts/odata/AuditAggregationOdata/?$filter=(FirstRead%20gt%20datetime%272019-01-01T00:00:00Z%27%20and%20FirstRead%20lt%20datetime%272019-01-03T00:00:00Z%27)
Error message:
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)"
Note:
Property Name="FirstRead" Type="Edm.DateTimeOffset"/
Thank you
filter connection odata
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
add a comment |
I try to get data to excel with OData. When I use link below it works fine:
http://xts/odata/AuditAggregationOdata
or
http://xts/odata/AuditAggregationOdata/?$filter=(ObjectId%20eq%2041143%20)
But when I try to use some date range or funcion with date it does not work. I try to write everything but without right result:
1.
http://xts/odata/AuditAggregationOdata/?$filter=year(FirstRead)%20eq%202016
Error message:
Unable to connect
We encountered an error while trying to connect
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)"
Or this one
2.
http://xts/odata/AuditAggregationOdata/?$filter=(FirstRead%20gt%20datetime%272019-01-01T00:00:00Z%27%20and%20FirstRead%20lt%20datetime%272019-01-03T00:00:00Z%27)
Error message:
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)"
Note:
Property Name="FirstRead" Type="Edm.DateTimeOffset"/
Thank you
filter connection odata
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
I try to get data to excel with OData. When I use link below it works fine:
http://xts/odata/AuditAggregationOdata
or
http://xts/odata/AuditAggregationOdata/?$filter=(ObjectId%20eq%2041143%20)
But when I try to use some date range or funcion with date it does not work. I try to write everything but without right result:
1.
http://xts/odata/AuditAggregationOdata/?$filter=year(FirstRead)%20eq%202016
Error message:
Unable to connect
We encountered an error while trying to connect
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Exception has been thrown by the target of an invocation.)"
Or this one
2.
http://xts/odata/AuditAggregationOdata/?$filter=(FirstRead%20gt%20datetime%272019-01-01T00:00:00Z%27%20and%20FirstRead%20lt%20datetime%272019-01-03T00:00:00Z%27)
Error message:
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.DateTime' for operator kind 'GreaterThan'.)"
Note:
Property Name="FirstRead" Type="Edm.DateTimeOffset"/
Thank you
filter connection odata
filter connection odata
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
asked Mar 25 at 14:12
palo173palo173
36 bronze badges
36 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It seems to be an internal server error.
When I tried different entity but with same conditions, it worked fine. I put the right solution below:
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=year(From)%20eq%202019
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=From%20ge%20datetimeoffset%272016-01-01%27%20and%20From%20lt%20datetimeoffset%272020-01-01%27
answered May 9 at 14:07
palo173palo173
36 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55339801%2fodata-string-error-and-problem-with-date-formats%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It seems to be an internal server error.
When I tried different entity but with same conditions, it worked fine. I put the right solution below:
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=year(From)%20eq%202019
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=From%20ge%20datetimeoffset%272016-01-01%27%20and%20From%20lt%20datetimeoffset%272020-01-01%27
answered May 9 at 14:07
palo173palo173
36 bronze badges
add a comment |
It seems to be an internal server error.
When I tried different entity but with same conditions, it worked fine. I put the right solution below:
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=year(From)%20eq%202019
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=From%20ge%20datetimeoffset%272016-01-01%27%20and%20From%20lt%20datetimeoffset%272020-01-01%27
answered May 9 at 14:07
palo173palo173
36 bronze badges
add a comment |
It seems to be an internal server error.
When I tried different entity but with same conditions, it worked fine. I put the right solution below:
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=year(From)%20eq%202019
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=From%20ge%20datetimeoffset%272016-01-01%27%20and%20From%20lt%20datetimeoffset%272020-01-01%27
answered May 9 at 14:07
palo173palo173
36 bronze badges
It seems to be an internal server error.
When I tried different entity but with same conditions, it worked fine. I put the right solution below:
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=year(From)%20eq%202019
http://xts/odata/ProfileData(path='Odata_test%7Codata_test')?$filter=From%20ge%20datetimeoffset%272016-01-01%27%20and%20From%20lt%20datetimeoffset%272020-01-01%27
answered May 9 at 14:07
palo173palo173
36 bronze badges
edited May 9 at 14:37
answered May 9 at 14:07
palo173palo173
36 bronze badges
answered May 9 at 14:07
palo173palo173
36 bronze badges
answered May 9 at 14:07
palo173palo173
36 bronze badges
36 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55339801%2fodata-string-error-and-problem-with-date-formats%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
