Azure Table API (Query Filter) For Timestamp

[MigsQuestionarre]

I want to ask about the query filter feature on the Azure Table API Source setting, I'm trying to transfer data from the Azure table API to a JSON file where the filter query uses the following timestamp query: "Timestamp ge datetime'2023-05-15T03:30:32.663Z"' after I run it already appears data transfer complete:

,but when looking at the json file nothing appears:

I want to make sure whether the feature for filtering queries for time already exists or not, or is there a writing error from what I input? thank you for your attention

the following additional notes are my migration settings:

[bowencode]

Queries can be tricky because of formatting. I think what you're seeing is probably a combination of the "eq" operator not getting an exact match or JSON encoding not actually reading the query as expected. Here's an example with a full time that matches a table timestamp and the JSON encoded characters:

"QueryFilter": "Timestamp eq datetime\u00272023-01-12T16:53:31.1714422Z\u0027"

With less precision on the query time it's probably better to use > and < to specify a range.

[MigsQuestionarre]

Hello Mr. Bowen thank you for the feedback, i have try the solution that you suggest but unfortunately the same problems are still occuring. after that I also tried several other formats to try to get the data I wanted to migrate into the .json file, this are the following log of the formats I tried:
"QueryFilter": "Timestamp ge datetime\u00272023-05-17T03:06:07.691Z\u0027" Success Transfer, Still no data in json file
"QueryFilter": "Timestamp le datetime\u00272023-05-17T03:06:07.691Z\u0027" Success Transfer, Still no data in json file
"QueryFilter": "Timestamp eq datetime\u00272023-05-17T03:06:07.691Z\u0027" Success Transfer, Still no data in json file
"QueryFilter": "Timestamp gt datetime\u00272023-05-17T03:06:07.691Z\u0027" Success Transfer, Still no data in json file
"QueryFilter": "Timestamp ge datetime '2023-05-17T03:06:07.691Z'" Success Transfer, no data in json file
"QueryFilter": "Timestamp le datetime '2023-05-17T03:06:07.691Z'" Success Transfer, no data in json file
"QueryFilter": "Timestamp gt datetime '2023-05-17T03:06:07.691Z'" Success Transfer, no data in json file
"QueryFilter": "Timestamp eq datetime '2023-05-17T03:06:07.691Z'" Success Transfer, no data in json file
"QueryFilter": "Timestamp ge datetime'\u00272023-05-17T03:06:07.691Z\u0027'" Success Transfer, Still no data in json file
"QueryFilter": "Timestamp eq \u00272023-05-17T03:06:07.691Z\u0027" Success Transfer, Still no data in json file
"QueryFilter": "Timestamp ge datetime '2023-05-17T03:10:39.058Z\u002B00:00'" Fail Transfer
"QueryFilter": "Timestamp ge datetime '2023-05-17T03:10:39.058Z\u002B00'" Fail Transfer
"QueryFilter": "Timestamp ge datetime 2023-05-17T03:10:39.058Z\u002B00" Fail Transfer
"QueryFilter": "Timestamp ge datetime'u00272023-05-17T03:06:07.691Zu0027'" Fail Transfer
"QueryFilter": "Timestamp eq '\u00272023-05-17T03:06:07.691Z\u0027'" Fail Transfer
in the right hand sight i put the status after i execute the dmt.

[philnach]

@MigsQuestionarre, I had Copilot improve the documentation to clarify DateTime QueryFilter format. Take a look at PR #231. Of your 15 queries 4 should have worked the rest had other issues, there's a detailed table in the PR calling out each one. We're going to update the documentation and close out this issue.

Queries 1-4: Syntactically correct but returned no data (likely because no entities matched the specific timestamp criteria, especially with eq operator)
Queries 5-9: Had encoding issues (spaces before quotes, not JSON-escaped)
Query 10: Missing datetime prefix
Queries 11-15: Multiple issues (invalid timezone format, wrong escape sequences, extra quotes)