I am doing some expense reporting in Excel, with data pulled via Repliconnect API. We are on Gen2.
One of my queries looks like this:
[
{
"Action": "Query",
"QueryType": "ExpenseByArguments",
"DomainType": "Replicon.Expense.Domain.Expense",
"Args": [
null,
null,
null,
{
"__type": "Date",
"Year": 2018,
"Month": 8,
"Day": 1
},
{
"__type": "Date",
"Year": 2018,
"Month": 8,
"Day": 31
},
null,
[]
],
"Load": [
{
"Relationship": "User",
"Domain": "Replicon.Domain.User"
},
{
"Relationship": "Entries",
"Domain": "Replicon.Expense.Domain.ExpenseEntry",
"Load": [
{
"Relationship": "Project",
"Domain": "Replicon.Project.Domain.Project",
"IdentityOnly": true
},
{
"Relationship": "ExpenseType",
"Domain": "Replicon.Expense.Domain.ExpenseType",
"IdentityOnly": false
}
]
}
]
}
]
The idea is to pull all expense entries (with project IDs and user info) for expenses incurred in a given date range. Based on the query documentation, this is what this should do.
However, what I am seeing is that it is pulling entries tied to expense sheets with an expense sheet date (where is that in the UI? creation date?) in the date range, and I am seeing expense entries out of range (e.g. including late July).
Is the only way to query based on Incurred Date to pull a bigger set of data and then filter it in my reporting spreadsheet?
Thanks,
Richard T
One of my queries looks like this:
[
{
"Action": "Query",
"QueryType": "ExpenseByArguments",
"DomainType": "Replicon.Expense.Domain.Expense",
"Args": [
null,
null,
null,
{
"__type": "Date",
"Year": 2018,
"Month": 8,
"Day": 1
},
{
"__type": "Date",
"Year": 2018,
"Month": 8,
"Day": 31
},
null,
[]
],
"Load": [
{
"Relationship": "User",
"Domain": "Replicon.Domain.User"
},
{
"Relationship": "Entries",
"Domain": "Replicon.Expense.Domain.ExpenseEntry",
"Load": [
{
"Relationship": "Project",
"Domain": "Replicon.Project.Domain.Project",
"IdentityOnly": true
},
{
"Relationship": "ExpenseType",
"Domain": "Replicon.Expense.Domain.ExpenseType",
"IdentityOnly": false
}
]
}
]
}
]
The idea is to pull all expense entries (with project IDs and user info) for expenses incurred in a given date range. Based on the query documentation, this is what this should do.
However, what I am seeing is that it is pulling entries tied to expense sheets with an expense sheet date (where is that in the UI? creation date?) in the date range, and I am seeing expense entries out of range (e.g. including late July).
Is the only way to query based on Incurred Date to pull a bigger set of data and then filter it in my reporting spreadsheet?
Thanks,
Richard T
Posted 2 years ago
Aashnee Kamboj, Community Moderator
That would be great! Thanks. Do you have my contact info?
Richard T
Richard T
Aashnee Kamboj, Community Moderator
Hi Richard,
One of our Support Representatives will be assisting you on this.
One of our Support Representatives will be assisting you on this.
A week later, I've still not heard from them. Please can you follow up.
Richard T
Richard T
Aashnee Kamboj, Community Moderator
Hi Richard,
I see an existing case and a couple of email communications sent over to you for connecting on the same. Is there a convenient time that our representative can reach out to you and help you with the same.
I see an existing case and a couple of email communications sent over to you for connecting on the same. Is there a convenient time that our representative can reach out to you and help you with the same.
My apologies - I found an email buried in my spam folder. I will follow up directly with Support. Thanks.
