can not reload data from Google Sheets with Japanese character in filename, sheet name or column name

[Wei Li]

Hi,

Great work for the excellent custom module.One of my customer is very interested in this.

I tried some test on my environment(Spotfire 10.10 in Japanese OS) and

I can not reload data from Google Sheets with Japanese character in filename, sheet name or column name.

Could you please confirm this behavor and fix it if confirmed

 

(I didn't recall that question/issue should be submitted here hence put it in the review part, please remove that review if possible too. Sorry for that)

Many Thanks.

Regards,

Wei Li

[Wei Li]

The error message is as below

 

ImportException at Spotfire.Dxp.Data:

 

System.Collections.Generic.KeyNotFoundException:

 

System.ThrowHelper.ThrowKeyNotFoundException()

 

System.Collections.Generic.Dictionary`2.get_Item(TKey key)

 

Spotfire.Dxp.Data.Adapters.GoogleSheetsCustom.GoogleSheetsCustomAdapterConnection.ExecuteQueryCoreImpl(SqlQuery query, QueryResultWriter resultWriter, CancellationToken cancellationToken)

 

:

 

Google Sheets (Custom)

Document ID:

 

1Zy9i5I_GeIiGbR7Skgd4dGeBChF9Yn9pHyY0SXGOW5Q

Document Name:

 

test-data

Document Type:

 

Google Sheet

Items:

 

1 (HRESULT: 80131500)

Stack Trace:

 

Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(ManagedDataConnection dataConnection, Guid virtualJoinViewId, DataTableSchema schema, Guid promptCollectionId, CxxSession session, IServiceProvider serviceProvider, GlobalMethodRegistry globalMethodRegistry, NotificationService notificationService, Int32 rowLimit, PendingViewRequestsManager pendingViewRequestsManager)

 

Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.GetColumnsAndProperties()

 

Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(DataColumnProducer producer, Boolean forceUpdate)

 

Spotfire.Dxp.Data.Persistence.DataPool.GetDerivedData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

 

Spotfire.Dxp.Data.Persistence.DataPool.GetData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

 

Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.PoolReferenceCompute_(DocumentNode node)

 

Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(NonSharedRuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode)

 

Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass33_1.b__0()

 

Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithLimitationTarget(ILimitationTarget limitationTarget, Executor executor)

 

Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.LookupOrEvaluateValue(StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode, StatelessDependencyDeclarer dependencyDeclarer)

 

Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.GetValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode)

 

Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass29_0.b__2()

 

Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action)

 

Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.b__29_0()

 

Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData(Boolean willPotentiallyLoadData)

 

Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__120.MoveNext()

 

Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__95.MoveNext()

 

Spotfire.Dxp.Data.DataTable.d__292.MoveNext()