Share your ideas

Create relational table query with the api

It would be very useful to create a relational table query with the api. Anybody who is implementing use cases that involve relational tables could benefit from that idea.

  • Guest
  • Feb 26 2020
Campaign
What is your industry? Marketing & Public Opinion Research
What is the idea priority? Urgent
  • Post comment
  • jh jh commented
    June 18, 2020 12:14

    Actual, you can do that with the current <CreateQuery> method.

    <Envelope>
    <    Body>
    <    CreateQuery>
    <    PARENT_LIST_ID>#Your relational table ID here#</PARENT_LIST_ID>
    <    QUERY_NAME>#Your query name here#</QUERY_NAME>
    <    VISIBILITY>1</VISIBILITY>
    <    CRITERIA>
    <    EXPRESSION criteria_type="rt_profile">
    <    COLUMN>#COLUM NAME#</COLUMN>
    <    CONJUNCTION>AND</CONJUNCTION>
    <    OPERATOR>is equal to</OPERATOR>
    <    VALUE>#SOME VALUE#</VALUE>
    </    EXPRESSION>
    <    EXPRESSIONcriteria_type="rt_profile">
    <    COLUMN>#ANOTHER COLUMN#</COLUMN>
    <    CONJUNCTION>AND</CONJUNCTION>
    <    OPERATOR>is equal to</OPERATOR>
    <    VALUE>#A VALUE#</VALUE>
    </    EXPRESSION>
    </    CRITERIA>
    </    CreateQuery>
    </    Body>
    </    Envelope>

    Attachments Open full size
  • +1

Related ideas