PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

|
|
|
FR
Inicio → WINDEV 2024 → Windev and Microsoft Dynamics CRM
Windev and Microsoft Dynamics CRM
Iniciado por stephane.golba, 13,feb. 2016 13:29 - 1 respuesta
#1
Miembro registrado
4 mensajes
Publicado el 13,febrero 2016 - 13:29
hi,

I search information to interfacing Windev (15 or 21 Express) and MS Dynamics CRM (Online or Onpremise) in version > 2011
(bulk loading)

It exists lot of way, all tested without success

Web service : (integration in WD work fine http://www.webservicex.net/whois.asmx…)
"Discovery" serve to return tonent Dynamics CRM available
URL : https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/Discovery.svc
https://crm4.dynamics.com/XRMServices/2011/Discovery.svc
https://disco.crm4.dynamics.com/XRMServices/2011/Discovery.svc
"Organization" serve to return tables
https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/Organization.svc…

in integration of "Webservices" in projet WD => unsuccess,
error "not document WSDL valid"
or unsuccess in of port 'CustomBinding_IDiscoveryService'. the binding associated 'CustomBinding_IDiscoveryService' not find.
or "no service find in webservice"
in call SOAP => unsuccess
HTTPParamètre(httpParamètreMode,1)
SOAP.StyleEncodage = "UTF-8"
SOAP.NameSpace = "CustomBinding_IOrganizationService"
ResExécution = SOAPExécute("https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/Discovery.svc?wsdl", "AccountSet","http://opentext/webservices/")

in HTTP request => unsuccess
sXMLSoap = ""
sXMLSoap += [
<?xml version="1.0" encoding="UTF-8"?>
<soap11_env:Envelope xmlns:soap11_env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap11_env:Body>
]
//sXMLSoap += [
//<GenerateGUID
//xmlns="http://opentext/webservices/">
//</GenerateGUID>
//]
sXMLSoap += [
</soap11_env:Body>
</soap11_env:Envelope>
]
HTTPParamètre(httpParamètreMode,1)
SI PAS HTTPRequête("https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/OrganizationData.svc/AccountSet","GenerateGUID","http://opentext/webservices/GenerateGUID") ALORS


API SDK (2015 et 2016) Dynamics :
Microsoft.xrm.sdk
Connection String with API of SDK => Microsoft.Xrm.Client.CrmConnection : unsuccess
vconnection is a CrmConnection("CRMOnline")
vconnection = CrmConnection.Parse ("Url=https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/Discovery.svc; Username=VOTRELOGIN; Password=VOTREPASSWORD;")
//vconnection = CrmConnection.Parse ("AuthType=Office365;Url=https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/Discovery.svc; Username=VOTRELOGIN; Password=VOTREPASSWORD;")
vservice is a OrganizationService(vconnection);
vcontext is a CrmOrganizationServiceContext(vconnection);

vService is a CrmService("AuthType=Office365;Url=https://VOTREENVIRONNEMENT.crm4.dynamics.com/XRMServices/2011/Discovery.svc; Username=VOTRELOGIN; Password=VOTREPASSWORD;")

other connection :
with Driver ODBC owner :
CData => Connection work but big time
with a Connection String ADODB : "PROVIDER=CRM Online Office 365;User=VOTRELOGIN;Password=VOTREPASSWORD;URL=https://crm4.dynamics.com/;CRM Version=CRM Online;Offline=false;"
an object OLE "ADODB.CONNECTION" => unsuccess

it's not concluding

i take all ideas, coding,
performing of bulk load with windev and Dynamics CRM,
a good practice of coding with API CRM


thanks to you, for helping...
#2
Publicado el 10,junio 2016 - 09:07
One of the places that I found really useful when seeking solutions to all Microsoft dynamics CRM related issues is http://dynamics.folio3.com/ They also have a CRM app that allows real time crm data integration without any hassle.
→ Volver a WINDEV 2024