# Read Google sheet API : ExceptionInInitializerError

**URL:** <https://forum.katalon.com/t/read-google-sheet-api-exceptionininitializererror/81872>\
**Category:** API Testing\
**Tags:** api-testing, katalon-studio\
**Created:** [December 27, 2022, 1:07pm UTC](https://forum.katalon.com/t/read-google-sheet-api-exceptionininitializererror/81872 "2022-12-27T13:07:41Z")\
**Posts on this page:** 1\
**Showing post:** 21

<div class="post-metadata">

**Author:** ![anon46315158](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@anon46315158](https://forum.katalon.com/u/anon46315158)\
**Post date:** [December 29, 2022, 9:43am UTC](https://forum.katalon.com/t/read-google-sheet-api-exceptionininitializererror/81872/21 "2022-12-29T09:43:31Z")

</div>

Looks like you have google-api-client 1.32.x which is quite old.  
On Maven central, latest is 2.1.1

[https://mvnrepository.com/artifact/com.google.api-client/google-api-client](https://mvnrepository.com/artifact/com.google.api-client/google-api-client)

So, I suggest, remove all of them, grab the latest from maven (using either maven or gradle) alongside all dependencies.

@kazurayam already provided some hints on how to do it, and if you search the forum you may find more tips and tricks on this matter.

e.g you can try the `Grape` trick:

> [@How to validate the JSON response with expected JSON schema](http://forum.katalon.com/t/how-to-validate-the-json-response-with-expected-json-schema/14029/3):
>
> So, here’s my approach. First, I add some .jar’s into my project: [Image: https://s3.amazonaws.com/katalon-forum/editor/4b/vcidfae4odcq.png] To grab them … you can manually search them into Maven central … or do a small trick: - Create a temporary custom keyword and put only this code into it (I name it Grab): package utilimport groovy.grape.Grape@Grab(group='org.everit.json', module='org.everit.json.schema', version='1.5.1')public class Grab {} - Once you hit ‘save’ katalon may looks like…

---

_[View the full topic](https://forum.katalon.com/t/read-google-sheet-api-exceptionininitializererror/81872)._
