Skip to main content

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?

1 answer
  1. Apr 13, 2023, 11:04 PM

    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

0/9000