Fails to retrieve 'timerange' values for some items on board

[matpearsons]

Hi there,

Im finding when I iterate through a board and try to pull the value for a timerange style column, it consistently fails to pull the value for some items, repeated running appears to produce the same results. i.e. it skips the same items each time.

Ive attached a screen grab of the board, and a screen grab of the output from a basic script I wrote to PoC the issue. Ive attached the script too.

Is it something ive messed up?

Many thanks.

Cheers,

Mat

date_sample.py.txt

[Ashatz]

@matpearsons

Thank you for bringing this to my attention. Honestly, it is hard to say what is happening here.

Would it be possible for you to query one of the items in question using the monday.com API playground? That way I may more properly see the state of your data and see if there is some missing data mapping in the Timeline column.

Thank you!

[Ashatz]

Hello Mat, I responded on Github regarding this issue. Similar to before, I would like to understand the state of underlying data in your system via a query result from the monday.com API playground. monday.com has gotten much better about ironing out data inconsistencies, but they are still around. I will know whether or not to rule this out once I have a glimpse of how the data is being returned for you. Thank you, Andrew

…

------- Original Message -------

On Wednesday, February 2nd, 2022 at 5:12 AM, matpearsons ***@***.***> wrote: Hi there, Im finding when I iterate through a board and try to pull the value for a timerange style column, it consistently fails to pull the value for some items, repeated running appears to produce the same results. i.e. it skips the same items each time. Ive attached a screen grab of the board, and a screen grab of the output from a basic script I wrote to PoC the issue. Ive attached the script too. Is it something ive messed up? Many thanks. Cheers, Mat [date_sample.py.txt](https://github.com/trix-solutions/moncli/files/7985425/date_sample.py.txt) [Screenshot 2022-02-02 at 09 56 21](https://user-images.githubusercontent.com/82215440/152133896-a27e349e-d5eb-4972-b064-ff97b00b96c2.png) [Screenshot 2022-02-02 at 09 57 30](https://user-images.githubusercontent.com/82215440/152133905-0c606fb9-6181-4a08-b95e-f4c944f592ff.png) — Reply to this email directly, [view it on GitHub](#213), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/ABDEVFPMYUDCSVLKXDMU5MDUZD7PRANCNFSM5NLTBS3A). Triage notifications on the go with GitHub Mobile for [iOS](https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675) or [Android](https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub). You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[matpearsons]

Andrew,

Many thanks for looking at this.
Hopefully the attached is what you are looking for? Let me know if you need anything further.

Cheers
Mat

[Ashatz]

Hello Mat, Could you please also include the "value" field for the column values as well? This is what moncli uses for parsing. Thank you! Sent from ProtonMail mobile

…

-------- Original Message --------

On Feb 7, 2022, 8:17 AM, matpearsons wrote: Andrew, Many thanks for looking at this. Hopefully the attached is what you are looking for? Let me know if you need anything further. Cheers Mat [Screenshot 2022-02-07 at 13 14 36](https://user-images.githubusercontent.com/82215440/152795161-34c84625-9990-4427-bdbe-f16ec3f95f44.png) — Reply to this email directly, [view it on GitHub](#213 (comment)), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/ABDEVFJLOND7RMVYMZD7AWTUZ7A7BANCNFSM5NLTBS3A). Triage notifications on the go with GitHub Mobile for [iOS](https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675) or [Android](https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub). You are receiving this because you commented.Message ID: ***@***.***>

[matpearsons]

Andrew,

Apologies, im not particularly familiar with the API playground, hopefully this is what you meant

Cheers

Mat

[Ashatz]

@matpearsons

Thank you for this. I will check this out today.

Andrew

[Ashatz]

@matpearsons

This was exactly what I was looking for, thank you!

The one thing that seemed strange was that for all of your values, the 'visualization_type' is coming in as a null value, something that does not occur in my environment when the milestone visualization option is not applied. I have accounted for this "additional" data format with the new v2.0.9.

Please let me know if you are still running into problems with this issue.

Thanks again!

[Ashatz]

Hello Mat, This was exactly what I was looking for. Thank you! As per the Github issue, I have identified the issue and resolved it thanks to your help. Funny thing, when timeline values in our system are not set to the milestone visualization, the API returns no 'visualizaiton_type' data at all... However the API returns 'visualization_type' as null... The timeline column value in moncli did not account for your scenario, so it has been added with the latest patch version. Please let me know if you still have problems with this issue. Thanks again! Andrew Pleasure and an honor, Andrew Shatz Chief Technology Officer ***@***.*** Mobile: (508) 365-8469 Home: (863) 674-1592

…

------- Original Message -------

On Monday, February 7th, 2022 at 8:39 AM, matpearsons ***@***.***> wrote: Andrew, Apologies, im not particularly familiar with the API playground, hopefully this is what you meant Cheers Mat [Screenshot 2022-02-07 at 13 36 41](https://user-images.githubusercontent.com/82215440/152798673-34373d7d-2127-4efa-a755-35ba283197ab.png) — Reply to this email directly, [view it on GitHub](#213 (comment)), or [unsubscribe](https://github.com/notifications/unsubscribe-auth/ABDEVFIP4MLK2FLCOTBWKPTUZ7DSBANCNFSM5NLTBS3A). Triage notifications on the go with GitHub Mobile for [iOS](https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675) or [Android](https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub). You are receiving this because you commented.Message ID: ***@***.***>

[matpearsons]

Andrew,

Many thanks, I can confirm that that has resolved it.

Cheers

Mat