Summary
The user is facing a parsing error while trying to implement incremental sync for a stream in a custom Odata connector. They have added a key-value pair in general query parameters and set up incremental sync with a cursor field. The error message indicates a syntax error at a specific position in the query.
Question
Hi, I have built a custom connector for Odata and I am trying to implement incremental sync for a stream but I am getting an error that I am not sure how to resolve. Below are some steps that implemented:
• Added key-value pair in general query parameters where key = $filter and value = GLTran_updatedDateTime ge {{ stream_interval.start_time }}
• Enabled “Incremental sync” and added GLTran_updatedDateTime as “Cursor field” and the format is %Y-%m-%dT%H:%M:%S.%f . “API Time Filtering Capabilities” has been set to Start from the drop down. “Start Datetime” has been set to User Input
• As per declared schema, this field is being pulled as string data type GLTran_updatedDateTime
• I am getting a parsing error when I try to test it as below:
"message": "Syntax error at position 33 in 'GLTran_updatedDateTime ge 2024-11-07T00:00:00.000000'.",```
_Is it possible to convert this airbyte variable `{{ stream_interval.start_time }}` to string?_
<br>
---
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1731077159157529) if you want
to access the original thread.
[Join the conversation on Slack](https://slack.airbyte.com)
<sub>
["odata-connector", "incremental-sync", "parsing-error", "airbyte-variable"]
</sub>