Repliconnect expense question

  • 1
  • Question
  • Updated 2 months ago
  • Acknowledged
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
Photo of Townend, Richard

Townend, Richard

  • 12 Posts
  • 1 Reply Like

Posted 3 months ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1623 Posts
  • 110 Reply Likes
Hi Richard,

We will need more details for the same. Can I have a support rep reach out to you?
Photo of Townend, Richard

Townend, Richard

  • 12 Posts
  • 1 Reply Like
That would be great! Thanks. Do you have my contact info?

Richard T
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1617 Posts
  • 110 Reply Likes
Hi Richard,

One of our Support Representatives will be assisting you on this.
Photo of Townend, Richard

Townend, Richard

  • 12 Posts
  • 1 Reply Like
A week later, I've still not heard from them. Please can you follow up.

Richard T
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1617 Posts
  • 110 Reply Likes
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.
Photo of Townend, Richard

Townend, Richard

  • 12 Posts
  • 1 Reply Like
My apologies - I found an email buried in my spam folder. I will follow up directly with Support. Thanks.