Solved CRM Integration | Initiative CRM | Custom CRM

Status
Not open for further replies.

bastien_alv

Platinum Partner
Advanced Certified
Joined
Jan 23, 2023
Messages
7
Reaction score
0
Hello,

I'm trying to create a CRM template for my CRM (Initiative CRM).

Concerning authentication, here's how I need to connect:

First API call (getchallenge): https://app.initiative-crm.com/wstiger.php?operation=getchallenge&username=XXXXXXXXXXXX

Which sends me back a token that takes 3 minutes.

Next, I need to send another API call (login):

https://app.initiative-crm.com/wstiger.php with body {Content-Type:application/x-www-form-urlencoded{"operation": "login", "username": "XXXXXXXXX", "accessKey": "XXXXXXX"}}

Knowing that the "AccessKey" is to be calculated according to the token returned in the "getchallenge" operation, concatenated with the "wsuserkey" value (personal access key to the webservice, which is fixed and never changes).

Once these 2 values have been concatenated, the md5 encryption function is applied to feed the "accessKey" parameter.

This request (login) returns a "sessionName", which must be in the parameters of any other API call for me to be authenticated.

So my first problem is: How do I apply this scenario in the XML template? (In postman, everything works, I can make my calls and see the responses in json etc.)

Example of an API request for a contact search via phone number:

https://app.initiative-crm.com/wstiger.php?operation=query&sessionName={{SessionName}}&query=SELECT * from Contacts WHERE phone='01 02 03 04 05';

Then I have another problem: we need to map the api response to the 3CX fields (email, firstname, lastname etc).
The problem is that when I call the api on the contact, the company name is stored in another table. How do I map the data to another table?

I'm attaching the API doc for my crm if that's any help: https://assets-global.website-files...41044a4f41_Documentation-API_REST_IN_v1.1.pdf


I hope I've explained my problem clearly.
Thank you in advance.

Sincerely
Alvecom | ANOUZET Bastien
 
Last edited:
This seems to be exactly the old interface provided by Vtiger. I can attach a quite old version of the template showing how to do that. Please note that this is not a working template, this was designed to work with old versions of 3CX, so it will not work out of the box. But the Auth scenario is what you need to take from there.
 
  • Like
Reactions: Evolute IT
Attaching, sorry.
 

Attachments

  • Like
Reactions: bastien_alv
Helo,

Thank for the template.

It work Out Of The Box :D

haha

thanks, can tag this post to solved
 
OK, it might work for contact lookup, but it will not provide contact creation, chat journaling, contact search from the Web Client, etc. If you just need contact lookup for calls, then you will be ok.
 
  • Like
Reactions: Evolute IT
Status
Not open for further replies.

Forum statistics

Threads
111,969
Messages
590,049
Members
164,881
Latest member
mdavis@housingresourcesin