Announcement

Collapse
No announcement yet.

How to use where parameter ? (API)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to use where parameter ? (API)

    How to use where api parameter ?
    I read the documentation but did not see the sample code. Could you give a simple example?

    var URL = `http://espocrm.com/api/v1/Lead?maxSize=20&where=lead.user.name ?`;

  • #2
    You can utilize this https://github.com/espocrm/documenta...-client-php.md

    Use browser's console to see requests for an example.

    Comment


    • #3
      Originally posted by yurikuzn View Post
      You can utilize this https://github.com/espocrm/documenta...-client-php.md

      Use browser's console to see requests for an example.
      I did not see the "where" command. I'm new Do you have a chance to help? Example code I'm use react native.

      where: { firstName: 'John' } I try this method but not work

      Comment


      • #4
        http://demo.espocrm.de/advanced/api/v1/Contact?where[0][type]=startsWith&where[0][attribute]=firstName&where[0][value]=Ro

        Comment


        • #5
          Originally posted by tanya View Post
          http://demo.espocrm.de/advanced/api/v1/Contact?where[0][type]=startsWith&where[0][attribute]=firstName&where[0][value]=Ro
          That's it! Thank you

          Comment


          • #6
            Hello,

            How would you request multiple selections? Example:

            ?where[0][type]=in&where[0][attribute]=assignmentType&where[0][value]=Event&where[0][value]=Mobile+Draw"

            I cannot get both "Event" and "Mobile Draw" to be filtered. Thanks for the help!

            Comment


            • #7
              This post isnt showing up for me on recent posts?? Adding a comment to refresh.

              Comment


              • #8
                Originally posted by bradaks View Post
                Hello,

                How would you request multiple selections? Example:

                ?where[0][type]=in&where[0][attribute]=assignmentType&where[0][value]=Event&where[0][value]=Mobile+Draw"

                I cannot get both "Event" and "Mobile Draw" to be filtered. Thanks for the help!
                Has anyone overcame this or know what I may be doing wrong? Thanks again!

                Comment


                • #9
                  Still trying to figure this out.

                  Comment


                  • #10
                    You can replicate the request via EspoCRM UI and copy the request URL from the browser console network tab.

                    Comment

                    Working...
                    X