Mautic REST API using custom getCustomList process

[mohanprasanthr]

HI, i was trying extract the contact from a particular period using mautic REST API using contact API.

$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 execute and print the above query it returns like

Array
(
    [select] => select * from leads
    [where] => Mautic\QueryBuilder\WhereBuilder Object
        (
            [clauses:protected] => Array
                (
                    [0] => Array
                        (
                            [col] => dateAdded
                            [expr] => eq
                            [val] => 2019-04-27 06:11:23
                        )
                )
            [composite:protected] => 
        )
)

but after executing the query it produces the following error in my system

[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.