An item with the same key has already been added.
i am using zoho analytics for fetching data. I have used sql queries for fetching data. I have 45 tables and I have used for loop for getting data from all tables. I can get data for the first iteration. For the second iteration I am getting error as,
An item with the same key has already been added.
I am getting error for the statement. It executes when intI is 0. It gives error for intI=1.
RepClient.ExportDataUsingSQL(tableURI, "JSON", strFile, strQry, config)
The code is as follows ,
- Dim objDT As New DataTable
- Dim objDS As New DataSet
- Dim intI As Integer
- Dim strTable As String
- ZCRMRestClient.Initialize(config)
- Dim client As ZohoOAuthClient = ZohoOAuthClient.GetInstance()
- Dim grantToken As String
- Dim tokens As ZohoOAuthTokens
- Dim accessToken As String = tokens.AccessToken
- Dim refreshToken As String = tokens.RefreshToken
- Dim RepClient As IReportClient
- Dim tableURI As String
- Dim strFile As String
- Dim strOP As String
- Dim jsonString
- For intI = 0 To objDTTable.Rows.Count - 1
- strFile = "d:\\Data.json"
- 'strQry = "select * from Customer WHERE ""Customer Name""='AKSHAR DEVELOPERS'"
- File.Delete(strFile)
- strTable = objDTTable.Rows(intI).Item("Analytics_Table_Name")
- strQry = "select * from " & strTable
- RepClient.ExportDataUsingSQL(tableURI, "JSON", strFile, strQry, config)
- strOP = JsonConvert.SerializeObject(strFile, Formatting.Indented)
- jsonString = File.ReadAllText(strFile)
- objDT = Tabulate(jsonString)
- 'ExportToExcel("d:\1.xls", objDT)
- CopyData(objDT, strTable)
- 'Threading.Thread.Sleep(360001)
- client = Nothing
- grantToken = Nothing
- tokens = Nothing
- accessToken = Nothing
- refreshToken = Nothing
- RepClient = Nothing
- tableURI = Nothing
- Next
- Return objDT