Error in connecting google sheet with Automation Edge

Get Help & Discuss Process Studio
, ,
1

I have integrated Google spreadsheet to Automation Edge where I have used API keys i.e. ‘Client ID’, ‘Client Secrete’, ‘Refresh Token’ to read the data from Google Sheets.

The process was running fine till yesterday, but today it is showing connection error with error message below:

Error Message on Process Studio: class org.apache.http.message.BasicNameValuePair cannot be cast to class org.apache.http.NameValuePair (org.apache.http.message.BasicNameValuePair is in unnamed module of loader com.automationedge.ps.core.plugins.KettleURLClassLoader @29ef3040; org.apache.http.NameValuePair is in unnamed module of loader ‘app’)

Error Message on T3 Portal: Error in step ( Read_BloodRecordSpreadSheet ) : class org.apache.http.message.BasicNameValuePair cannot be cast to class org.apache.http.NameValuePair (org.apache.http.message.BasicNameValuePair is in unnamed module of loader com.automationedge.ps.core.plugins.KettleURLClassLoader @22ecb928; org.apache.http.NameValuePair is in unnamed module of loader ‘app’)

2

Here’s the resolution,

I have replaced the Google sheet plugin file with one provided by automation edge support team.

Download the plugin file
Replace it in plugins >> google sheet folder
restart the process studio
test the connection.

Thank you A. E. support team for providing the resolution.