Query ContactPayment by Date not working

Options
Rachel Bender
Rachel Bender ✭
Ancient Membership Facilitator 1
in API
This is my query: SELECT * FROM ContactPayment where Date between '2014-07-10' and '2014-07-11' order by Date ASC It alternately returns a timeout error and this: SOAP Fault: (faultcode: HTTP, faultstring: Method Not Allowed) However, the docs say that this method is, indeed, allowed. https://www.blackbaud.com/files/support/helpfiles/connect/Content/ContactPayment.htm I am able to query by ContactID, so I know there is data in the entity. Any help / advice would be greatly appreciated.

Comments

  • Eric Pecoraro
    Eric Pecoraro ✭
    Ancient Membership Facilitator 1
    Rachel Bender:
    This is my query: SELECT * FROM ContactPayment where Date between '2014-07-10' and '2014-07-11' order by Date ASC It alternately returns a timeout error and this: SOAP Fault: (faultcode: HTTP, faultstring: Method Not Allowed) However, the docs say that this method is, indeed, allowed. https://www.blackbaud.com/files/support/helpfiles/connect/Content/ContactPayment.htm I am able to query by ContactID, so I know there is data in the entity. Any help / advice would be greatly appreciated.
    ContactPayment has been deprecated for several years now (8 I'm thinking). Consequently there has been no optimization for that entity/data since then.



    I would recommend using PaymentItem instead if possible...
  • Rachel Bender
    Rachel Bender ✭
    Ancient Membership Facilitator 1
    Eric Pecoraro:
    ContactPayment has been deprecated for several years now (8 I'm thinking). Consequently there has been no optimization for that entity/data since then.



    I would recommend using PaymentItem instead if possible...
    Right, but ContactPayment returns a lot of fields that PaymentItem does not ...
  • Eric Pecoraro
    Eric Pecoraro ✭
    Ancient Membership Facilitator 1
    Rachel Bender:
    Right, but ContactPayment returns a lot of fields that PaymentItem does not ...
    Correct. However, you can get to many of those fields through table/entity relationships.



    PaymentItem relates directly to ContactProfile, GiftItem & Order entities. GiftItem, then relates to a number of other entities.



    Check out: http://shepardclient.s3.amazonaws.com/sphere/Shepard.com-Sphere-ERD.pdf



    Complex, but doable, depending upon the specific field requirements.



    In any case ContactPayment cannot be relied upon unfortunately...unless Blackbaud/Kintera decides to support it.

Categories