page-user page-user-sajad-shiravi-1451 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Data Connector - HTTP request error 403

Excellent thank you for your patience. Yeah turns out that Postman can't handle the URL redirect. Tableau is similar so if you're interested the URL can be found under the Tableau tab in the Data Connector page in MyG.

Can you use this URL and add your date filter to this instead of the one you are using?https://odata-connector-ca-1.geotab.com/odata/v4/svc/

Hi, Source: <a href="https://docs.google.com/document/d/1Ylb3SrtEIvv7f_ndsUPCB0A5eQDzP43TiXycIzgC_7k/edit?tab=t.0#heading=h.rtxt2ciwi0bm" target="_blank">this document</a>. Postman, by default, strips the Authorization header when it follows a redirect to a different host. This is a security feature designed to prevent your sensitive credentials from being sent to an untrusted third-party server. When a server responds with a redirect status code (like a 301 or 302), it's telling the client to make a new request to a different URL. For security reasons, Postman won't automatically include the Authorization header in this subsequent request, especially if the new URL is on a different domain. The new, unauthenticated request then fails, resulting in an error code like 400 Bad Request or 403 Forbidden. To fix this, you need to manually add the Authorization header to the request. Instead of relying on the built-in "Authorization" tab, you should go to the Headers tab and explicitly create a new header with the key Authorization and its corresponding value. This ensures the header is included in every part of the request, even after a redirect.

Thanks for your question. Geotab Ace's query execution is read-only which eliminates the possibility of any modifications on the database. There are a number of safegaurds in place. Please refer to this document: <a href="https://www.geotab.com/CMS-GeneralFiles-production/data/Geotab%20Ace%20-%20Responsible%20AI%20Whitepaper%20[PUB]%202024.pdf" target="_blank">https://www.geotab.com/CMS-GeneralFiles-production/data/Geotab%20Ace%20-%20Responsible%20AI%20Whitepaper%20[PUB]%202024.pdf</a> Ace currently does not support asset inspections data. If it is however set as a rule you can use the @ feature to search for the exception and get the results.  For a quick session on Ace view this video:<a href="https://drive.google.com/file/d/14LaZhXNdysX71UYcug569GXN895kbolS/view?usp=sharing" target="_blank">https://drive.google.com/file/d/14LaZhXNdysX71UYcug569GXN895kbolS/view?usp=sharing</a> <a href="https://docs.google.com/document/d/1UOfJAj48VqrQLqk_C13CCOl9NnFf_FWgjXSyAX9IiRg/edit#heading=h.z27x8yefc1ly" target="_blank">User Guide</a><a href="https://docs.google.com/document/d/17UVG4EDoNRbX6JEiAk5NTAuKEX2NEWLkGDVphpWNvjA/edit#heading=h.atvyw73zqz6j" target="_blank">Prompt Guide</a> If you need further training please don't hesitate to reach out to me directly: sajadshiravi@geotab.com

SQL Ingection for Geotab Ace Feature

This is my email feel free to email me directly:sajadshiravi@geotab.com

Geotab Ace SQL output to use in report

Thanks yes Sajad here :)Query saving is on our roadmap but let me see what I can do in the short term to expand the character limit there for your to input queries to run

Hi There, I'm the PM for Ace and really glad to hear you're liking the output. You're reading our mind!Next steps is to allow you to save the queries and hopefully get the queries integrated into other parts of the software like reports and dashboard. Please stay tuned while we get these shipped.

Sorry to hear that. Can you please contact your reseller directly about this. Happy to support from the Geotab side.

Odometer Data Frequency in API

Hi, have you tried the <a href="https://marketplace.geotab.com/solutions/data-connector/" target="_blank">Geotab Data Connector</a>? Data Connector gives you a single Odometer reading for each vehicle in the daily table. Also available at the monthly aggregation. Let me know if you have questions.

Recent Activity