Hi, I hope someone here can help me.
I have been trying to establish a connection to ZohoCRM using FireDac CDataZohoCRM component and I have failed 100% of my attempts.
I do have a general idea on how the OAuth protocol works. To help myself understanding I have used Postman to test the parameters I use (client_id, client_secret, tokens etc) From Postman I did not encounter any difficulty.
I believe that the main issue I am finding with the FireDac CDataZohoCRM is the amount of granularity that your component offers it is a bit overwhelming. I am sure that the granularity offered it is probably a great asset for someone that has an expertise on this. However as a beginner, I got into a point where I would have to brute force the component testing every single permutation and combination to isolate my mistakes on the misuse of the connector.
A I understand from the documentation the SSLServerCert attribute it is not mandatory here and it can be replaced by a “*”. Not secured but not mandatory.
I don’t know what I am doing wrong and I would appreciate same help. I enclose the parameters that I have now (I intentionally removed some characters from the ClientID, ClientSecret and tokens for security reasons).
I have also tried to run the Wizard providing the Client ID and the Client Secret parameters but I have not been able to succeed.
I am also aware on the delays of the generated tokens so I always worked within the time frame that Zoho allows me.
I generated OAuthRefreshToken on Postman and as you can see It did properly generate.
If anyone out there has a printscreen of a working connector I would really appreciate if you can share it with me. Just cover the sensitive information. I have the feeling that I am just a few attributes away from making it work I just don’t know which ones.
Please see my settings below. I also uploaded a log file with more details.
(The application that I am attempting to write is in Delphi Alexandria Enterprise Edition)
Thank you all.
================================
Connection definition parameters
================================
SSLServerCert=*
InitiateOAuth=GETANDREFRESH
OAuthClientId=*****
OAuthClientSecret=******
APIDomain=https://www.zohoapis.com
OAuthAccessToken=*****
OAuthRefreshToken=*****
ProxySSLType=NEVER
Logfile=c:\temp\zoho.txt
Verbosity=5
CallbackURL=https://formacion.com
DriverID=CDataZohoCRM
Pooled=False
================================
FireDAC info
================================
Tool = RAD Studio 11.0
FireDAC = 28.0.0 (Build 106147)
Platform = Windows 32 bit
Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR
================================
Client info
================================
Loading driver CDataZohoCRM ...
Creating CData environment handle
================================
Session info
================================
Failed to connect to DBMS !
tFireDAC]