OAuth1a signature is invalid when requesting getCustomList() in mautic API

[mohanprasanthr]

[2019-06-13 04:42:55] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: "signature_invalid" at /var/www/html/mautic/vendor/willdurand/oauth-server-bundle/Service/OAuthServerService.php line 244 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\HttpException(code: 0): signature_invalid at /var/www/html/mautic/vendor/willdurand/oauth-server-bundle/Service/OAuthServerService.php:244)"} []

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[Woeler]

Need more information. What version of the api library, what version of Mautic?

[mohanprasanthr]

I am using mautic latest version (2.15.1) and latest version of API library. i want to extract the leads based on date_added.so i am using the following function

$queryBuilder = new QueryBuilder();
$queryBuilder->setSelect("select * from leads");
$queryBuilder->setWhere($queryBuilder->expr()->eq('dateAdded', '2019-04-27 06:11:23'));
$contacts = $contactApi->getCustomList($queryBuilder);

when i using without where condition it works fine,but including where condition it produces the error like "signature_invalid" FYI : the following function present in Api/Api.php file

 public function getCustomList(QueryBuilder $queryBuilder, $start = 0, $limit = 0)
   {
     
       $parameters = array(
           'select' => $queryBuilder->getSelect(),
           'where'  => $queryBuilder->getWhere(),
           'order'  => $queryBuilder->getOrder(),
           'start'  => $start,
           'limit'  => $limit,
       );
       
       $parameters = array_filter($parameters);

       $supported = $this->isSupported('getList');
       
       return (true === $supported) ? $this->makeRequest($this->endpoint, $parameters) : $supported;
   }

kindly give some advise to extract the leads based on some condition