I use the web data connector to connect Tableau desktop with ArangoDB. So for fetching the data from the database I write a AQL query which will than import the data into tableau. I am able to run the same query in Arango and see that the query is working but when I am running it in the web data connector I am facing an error message. I have attached the error message screen shot. Kindly see below for the query which I am trying to run:
FOR data IN insurancereportlog
FILTER data.visitdate > '2022-01-01' and data.visitdate < '2022-01-08'
LET varData = data.attendingProvider
FILTER LENGTH(varData) > 0
FOR dataNew IN varData
sort data._id desc
RETURN { id:data._id, patientId: data.patientId, visitdate: data.visitdate,
VisitDateTime: dataNew.VisitDateTime, BillDuration: dataNew.billDuration,
BillRate: dataNew.billRate, claimunits: dataNew.claimUnit, Duration: dataNew.duration,
Endtime: dataNew.endTime, Starttime: dataNew.startTime,
Firstname: dataNew.firstName, LastName: dataNew.lastName,
npiNumber: dataNew.npiNumber, visitNumber: dataNew.visitNumber,
procedureCode:data.procedureCode, patientFName: data.logdata.patientFName, patientLName: data.logdata.patientLName,
facility: data.logdata.facility, serviceUnit: data.logdata.serviceUnit, clinicientID: data.clinicientID,
claimStatus: data.claimStatus, payerName: data.logdata.payerName, Approved_amt:data.Approved_amt,
Claim_amt: data.Claim_amt, expectedAmount: data.expectedAmount, lineItemChargeAmount: data.logdata.lineItemChargeAmount,
pat_ctrl_num: data.pat_ctrl_num, Claim_header_id: data.Claim_header_id, payerId: data.logdata.payerId,
Adjusted_amt: data.Adjusted_amt, released_date: data.released_date, paidNumber: data.paidNumber,
Adjudication_date: data.Adjudication_date, Check_dt1: data.Check_dt1, created_date: data.created_date,
upload_date: data.upload_date, Reason_cd: data.Reason_cd}
How to avoid this going forward?
Hi Diya,
This question has been open for a while now without any responses - by any chance have you discovered anything further that might assist forums users respond to your query ?
Peter