Dirk Mautes

Hi, I have the same issue, but the square brackets didn't seem to do the trick. Any idea on what I'm doing wrong? My config: { "APIKey": "********************", "InstanceID": "********", "Database":{ "Driver": "mssql", "Server": "********", "Database": "HornbillData", "Authentication": "SQL", "UserName": "xxxx", "Password": "*********, "Port": 1433, "Encrypt": false }, "Reports":[ { "ReportID":178, "ReportName":"************", "DeleteReportInstance": true, "DeleteReportLocalFile": true, "UseXLSX": false, "Table":{ "TableName":"HornbillData", "PrimaryKey":"[Requests->Request ID]", "Mapping":{ "Requests->Activity Stream ID":"[Requests->Activity Stream ID]", "Requests->Archived":"[Requests->Archived]", "Requests->BPM Activity Update ID":"[Requests->BPM Activity Update ID]", "Requests->BPM authorised":"[Requests->BPM authorised]", "Requests->BPM ID":"[Requests->BPM ID]", "Requests->BPM Stage Expired":"[Requests->BPM Stage Expired]", "Requests->BPM UI state":"[Requests->BPM UI state]", "Requests->Call Back Date":"[Requests->Call Back Date]", "Requests->Cancellation Reason":"[Requests->Cancellation Reason]", "Requests->Catalog":"[Requests->Catalog]", "Requests->Catalog ID":"[Requests->Catalog ID]", "Requests->Category ID":"[Requests->Category ID]", "Requests->Category Name":"[Requests->Category Name]", "Requests->Closed By Team":"[Requests->Closed By Team]", "Requests->Closed By Team ID":"[Requests->Closed By Team ID]", "Requests->Closed By User ID":"[Requests->Closed By User ID]", "Requests->Closed By Username":"[Requests->Closed By Username]", "Requests->Closure Category ID":"[Requests->Closure Category ID]", "Requests->Closure Category Name":"[Requests->Closure Category Name]", "Requests->Company":"[Requests->Company]", "Requests->Company ID":"[Requests->Company ID]", "Requests->Created By":"[Requests->Created By]", "Requests->Custom 21":"[Requests->Custom 21]", "Requests->Custom 22":"[Requests->Custom 22]", "Requests->Custom 23":"[Requests->Custom 23]", "Requests->Custom 24":"[Requests->Custom 24]", "Requests->Custom 25":"[Requests->Custom 25]", "Requests->Custom 26":"[Requests->Custom 26]", "Requests->Custom 27":"[Requests->Custom 27]", "Requests->Custom 28":"[Requests->Custom 28]", "Requests->Custom 29":"[Requests->Custom 29]", "Requests->Custom 30":"[Requests->Custom 30]", "Requests->Custom A":"[Requests->Custom A]", "Requests->Custom B":"[Requests->Custom B]", "Requests->Custom C":"[Requests->Custom C]", "Requests->Custom D":"[Requests->Custom D]", "Requests->Custom E":"[Requests->Custom E]", "Requests->Custom F":"[Requests->Custom F]", "Requests->Custom G":"[Requests->Custom G]", "Requests->Custom H":"[Requests->Custom H]", "Requests->Custom I":"[Requests->Custom I]", "Requests->Custom J":"[Requests->Custom J]", "Requests->Custom K":"[Requests->Custom K]", "Requests->Custom L":"[Requests->Custom L]", "Requests->Custom M":"[Requests->Custom M]", "Requests->Custom N":"[Requests->Custom N]", "Requests->Custom O":"[Requests->Custom O]", "Requests->Custom P":"[Requests->Custom P]", "Requests->Custom Q":"[Requests->Custom Q]", "Requests->Custom R":"[Requests->Custom R]", "Requests->Custom S":"[Requests->Custom S]", "Requests->Custom T":"[Requests->Custom T]", "Requests->Customer ID":"[Requests->Customer ID]", "Requests->Customer Name":"[Requests->Customer Name]", "Requests->Customer Organization Container ID":"[Requests->Customer Organization Container ID]", "Requests->Customer type":"[Requests->Customer type]", "Requests->Date Closed":"[Requests->Date Closed]", "Requests->Date Logged":"[Requests->Date Logged]", "Requests->Date Modified":"[Requests->Date Modified]", "Requests->Date Placed On Hold":"[Requests->Date Placed On Hold]", "Requests->Date Resolved":"[Requests->Date Resolved]", "Requests->Description":"[Requests->Description]", "Requests->Due Date":"[Requests->Due Date]", "Requests->External Reference Number":"[Requests->External Reference Number]", "Requests->Feedback Status":"[Requests->Feedback Status]", "Requests->Feedback Status ID":"[Requests->Feedback Status ID]", "Requests->First Time Fix":"[Requests->First Time Fix]", "Requests->Freetext Search Index":"[Requests->Freetext Search Index]", "Requests->Historic Request":"[Requests->Historic Request]", "Requests->Image":"[Requests->Image]", "Requests->Impact":"[Requests->Impact]", "Requests->Impact Id":"[Requests->Impact Id]", "Requests->Is Analyst Unread":"[Requests->Is Analyst Unread]", "Requests->Is Customer Unread":"[Requests->Is Customer Unread]", "Requests->Last Date Email Sent":"[Requests->Last Date Email Sent]", "Requests->Last Update Activity ID":"[Requests->Last Update Activity ID]", "Requests->Last Updated By":"[Requests->Last Updated By]", "Requests->Last Updated By ID":"[Requests->Last Updated By ID]", "Requests->Last Updated By Type":"[Requests->Last Updated By Type]", "Requests->Last Updated By User Type":"[Requests->Last Updated By User Type]", "Requests->Locked":"[Requests->Locked]", "Requests->On Hold Until":"[Requests->On Hold Until]", "Requests->Organisation Id":"[Requests->Organisation Id]", "Requests->Priority ID":"[Requests->Priority ID]", "Requests->Priority Name":"[Requests->Priority Name]", "Requests->Profile Code":"[Requests->Profile Code]", "Requests->Rating":"[Requests->Rating]", "Requests->Related Activity ID":"[Requests->Related Activity ID]", "Requests->Reopen Date":"[Requests->Reopen Date]", "Requests->Reopened By Team":"[Requests->Reopened By Team]", "Requests->Reopened By Team ID":"[Requests->Reopened By Team ID]", "Requests->Reopened By User ID":"[Requests->Reopened By User ID]", "Requests->Reopened By Username":"[Requests->Reopened By Username]", "Requests->Reopened Count":"[Requests->Reopened Count]", "Requests->Request ID":"[Requests->Request ID]", "Requests->Request Language":"[Requests->Request Language]", "Requests->Request Owner ID":"[Requests->Request Owner ID]", "Requests->Request Owner Name":"[Requests->Request Owner Name]", "Requests->Request Owner Type":"[Requests->Request Owner Type]", "Requests->Request Prefix":"[Requests->Request Prefix]", "Requests->Request Resolution Timer ID":"[Requests->Request Resolution Timer ID]", "Requests->Request Resolve By":"[Requests->Request Resolve By]", "Requests->Request Resolve Seconds":"[Requests->Request Resolve Seconds]", "Requests->Request Resolve Time":"[Requests->Request Resolve Time]", "Requests->Request Respond By":"[Requests->Request Respond By]", "Requests->Request Response Seconds":"[Requests->Request Response Seconds]", "Requests->Request Response Time":"[Requests->Request Response Time]", "Requests->Request Response Timer ID":"[Requests->Request Response Timer ID]", "Requests->Request Total Onhold Time":"[Requests->Request Total Onhold Time]", "Requests->Request Type":"[Requests->Request Type]", "Requests->Resolution":"[Requests->Resolution]", "Requests->Resolved By Team":"[Requests->Resolved By Team]", "Requests->Resolved By Team ID":"[Requests->Resolved By Team ID]", "Requests->Resolved By User ID":"[Requests->Resolved By User ID]", "Requests->Resolved By Username":"[Requests->Resolved By Username]", "Requests->Service ID":"[Requests->Service ID]", "Requests->Service Level Agreement ID":"[Requests->Service Level Agreement ID]", "Requests->Service Level Agreement Name":"[Requests->Service Level Agreement Name]", "Requests->Service Level Changed":"[Requests->Service Level Changed]", "Requests->Service Level Date Changed":"[Requests->Service Level Date Changed]", "Requests->Service Level ID":"[Requests->Service Level ID]", "Requests->Service Level Name":"[Requests->Service Level Name]", "Requests->Service Name":"[Requests->Service Name]", "Requests->Site":"[Requests->Site]", "Requests->Site ID":"[Requests->Site ID]", "Requests->Social Object Ref":"[Requests->Social Object Ref]", "Requests->Social Object URN":"[Requests->Social Object URN]", "Requests->Source ID":"[Requests->Source ID]", "Requests->Source Type":"[Requests->Source Type]", "Requests->Status":"[Requests->Status]", "Requests->Sub-status Id":"[Requests->Sub-status Id]", "Requests->Sub-status Text":"[Requests->Sub-status Text]", "Requests->Summary":"[Requests->Summary]", "Requests->Team ID":"[Requests->Team ID]", "Requests->Team Name":"[Requests->Team Name]", "Requests->Urgency":"[Requests->Urgency]", "Requests->Urgency Id":"[Requests->Urgency Id]", "Requests->Within Resolve Time":"[Requests->Within Resolve Time]", "Requests->Within Response Time":"[Requests->Within Response Time]", "owner->E-Mail":"[owner->E-Mail]", "owner->First Name":"[owner->First Name]", "owner->Last Name":"[owner->Last Name]", "owner->User Id":"[owner->User Id]", "RaisedBy->E-Mail":"[RaisedBy->E-Mail]", "RaisedBy->First Name":"[RaisedBy->First Name]", "RaisedBy->Last Name":"[RaisedBy->Last Name]", "RaisedBy->Name":"[RaisedBy->Name]", "RaisedBy->User Id":"[RaisedBy->User Id]", "owner->Name":"[owner->Name]" } } } ] } My log: 2022/01/24 09:52:26 ---- Hornbill Data Export Tool v1.7.1 ---- 2022/01/24 09:52:26 Flag - Configuration File: conf.json 2022/01/24 09:52:26 Flag - Debug: false 2022/01/24 09:52:26 [DEBUG] Loading Config File: C:\hbexport/conf.json 2022/01/24 09:52:26 Instance ID: leica 2022/01/24 09:52:26 [DEBUG] Connecting to Database Server: *********** 2022/01/24 09:52:26 2022/01/24 09:52:26 Running Report: DM LBS all requests raw dump all requests updated since start of last month [178] 2022/01/24 09:52:26 Checking Report Run ID [5379] for completion... 2022/01/24 09:52:29 Checking Report Run ID [5379] for completion... 2022/01/24 09:52:33 Checking Report Run ID [5379] for completion... 2022/01/24 09:52:33 Retrieving CSV Report File DM LBS all requests raw dump all requests updated since start of last month_5379.csv... 2022/01/24 09:52:33 Report File URL: https://mdh-p01-api.hornbill.com/******//dav/reports/178/DM LBS all requests raw dump all requests updated since start of last month_5379.csv 2022/01/24 09:52:33 Retrieved report data from C:\hbexport/reports/D********************************************.csv 2022/01/24 09:52:33 Processing 204 Records from DM LBS all requests raw dump all requests updated since start of last month_5379.csv... 2022/01/24 09:52:33 [DATABASE] Connection Successful 2022/01/24 09:52:33 [ERROR] [DATABASE] NamedExec Error: could not find name Requests in map[string]interface {}{"RaisedBy->E-Mail":"xxx.xxx@xxx.com", "RaisedBy->FirstName":"xxxx", "RaisedBy->LastName":"xxxx", "RaisedBy->Name":"xxx", "RaisedBy->UserId":"xxxx@xxxx",