Infusionsoft New Data Source In Klipfolio

API Q&A
1

I’m very new to working with API’s and I’m trying to add Infusionsoft as a new data source in Klipfolio.

I’m trying to pull a total $ amount from a custom field for all contacts. The field is “Lifetime Order Total” and the database name is “LifetimeOrderTotal”. How do I configure this to pull that data?

<?xml version='1.0' encoding='UTF-8'?>
<methodCall>
  <methodName>DataService.findByField</methodName>
  <params>
    <param>
      <value><string>privateKey</string></value>
    </param>
    <param>
      <value><string>tableName</string></value>
    </param>
    <param>
      <value><int>limit</int></value>
    </param>
    <param>
      <value><int>page</int></value>
    </param>
    <param>
      <value><string>fieldName</string></value>
    </param>
    <param>
      <value><string>fieldValue</string></value>
    </param>
    <param>
      <value><array>
        <data>
          <value><string>returnField1</string></value>
        </data>
      </array></value>
    </param>
  </params>
</methodCall>

Below is my initial go at it. Is this right or am I way off? I’m not quite sure what values go in to replace “fieldValue” or “returnField1”.

<methodCall>
  <methodName>DataService.findByField</methodName>
  <params>
    <param>
      <value><string>XXXXXXXXXXXXX</string></value>
    </param>
    <param>
      <value><string>Contact</string></value>
    </param>
    <param>
      <value><int>1000</int></value>
    </param>
    <param>
      <value><int>0</int></value>
    </param>
    <param>
      <value><string>LifetimeOrderTotal</string></value>
    </param>
    <param>
      <value><string>fieldValue</string></value>
    </param>
    <param>
      <value><array>
        <data>
          <value><string>returnField1</string></value>
        </data>
      </array></value>
    </param>
  </params>
</methodCall>

Is there an easier way to pull the data I want from Infusionsoft to Klipfolio that, as a newbie, I don’t know or understand?Preformatted text

2

Are you using XML because Klipfolio is requiring it? The IS API has a SDK but I’m getting the idea that you’re trying to do this without actual code?

Normally, a language like PHP is used to grab that information using REST endpoints or the SDK and then, if you have to format it for XML, you would use the information you gathered with the api and then convert it to XML…So are you using a programming language of any sort? You really can’t do what you’re describing without it.

3

Screen Shot 2019-12-16 at 8.49.07 AM
Screen Shot 2019-12-16 at 8.49.07 AM2880×1800 561 KB

This is what I see when trying to add a new data source in Klipfolio. Again, I’m very new to this and I am wondering if I’m trying to add IS as a new data source in the most difficult way?

4

Ok, so to start with, you need to replace with your api key.