1 Reply Latest reply on Apr 26, 2018 8:58 PM by Sanford Whiteman

    API Data - How to use data

    Alex Sanchez Arocha

      Hi,

       

      I'm creating a data warehouse using the Rest API and getting activities and leads has been straight forward. But I also need to bring programs (with tags) and emails so I have a few questions:

      • The only way to get programs with tags is by individually requesting the program using the id? Is there a possibility to add it to a browse call?
      • How can I tie activities to programs and leads, the intend is to build a summary of activities by programs. For example, I would like to have a program (name and tags), email (name, subject) and a summary of activities (sent, opened, clicked,...). The main question is which fields can I use to join the information (program, email, activity)

       

      Thanks,

        • Re: API Data - How to use data
          Sanford Whiteman
          • The only way to get programs with tags is by individually requesting the program using the id? Is there a possibility to add it to a browse call?

          The details are not surfaced unless you do the individual request.

           

          • How can I tie activities to programs and leads, the intend is to build a summary of activities by programs. For example, I would like to have a program (name and tags), email (name, subject) and a summary of activities (sent, opened, clicked,...). The main question is which fields can I use to join the information (program, email, activity)

          Everything you see in the Activity Log extract is what you have to go on.  There's no separate junction table.