Connection from web service to obtain GUID

(0) Share

Report

Posted on by Community Member

Hi,

I have set up the connection between my (ETL GENIO / OTIC ) and CRM Microsoft Dynamics ( https://soneparfr.crm4.dynamics.com ) using webservices

First, I try to retrieve a GUID from the dynamics CRM with the ETL (OTIC/GENIO) interface, but I can't find witch 4251.WSDL_5F00_Properties.png

hosname I have to use, with wirch endpoint ?

Second part : the WSDL protterties, in the same way, witch Location and Biding to use ?

Thank you in advance,

Best Regards

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

Hi Guido,

Thank you for your interest. How can I do check ? A simulation was conducted by the ETL specialists confirms the possibility to communicate with web services Dynamics CRM online authentication. But I don't know how they can retrieve this GUID.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok Guido,

I called back them, and they said : "

Should be published your own webservice ( GUIDgenerator.asmx , for example).

Thus , you will have :

- For your WSDL : http : // <TonServeurWeb>/<TonAppliWeb>/GUIDGenerator.asmx?WSDL

- To your End point: <TonAppliWeb>/GUIDGenerator.asmx "

In GUIDgenerator.asmx get the call to the GUID generator.

=> Otherwise, do you have a suggestion of new endpoint to use (.svc) with a HostName for the generation of GUI ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guido,

After several trials, I can not connect to the next step, after retrieving the GUID : the Security Token :

You can see below, the connection that I use :

And the request in XML File, that I built with my ETL :

----------------------------------------------------------

Content-Length: int

<?xml version='1.0' encoding='UTF-8'?>

<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:t="http://schemas.xmlsoap.org/ws/2005/02/trust" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">

   <s:Header>

    <a:Action s:mustUnderstand="1">http://schemas.xmlsoap.org/ws/2005/02/trust/RST/Issue</a:Action>

    <a:MessageID>2101610d-9b88-4398-8b7e-344299cb0b13</a:MessageID>

    <a:ReplyTo>

      <a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>

    </a:ReplyTo>

    <VsDebuggerCausalityData xmlns="http://schemas.microsoft.com/vstudio/diagnostics/servicemodelsink">uIDPo2V68j15KH9PqGf9DWiAfGQAAAAA/Dr1z6qvqUGzr5Yv4aMcdIr9AKDFU7VHn7lpNp0zeXEACQAA</VsDebuggerCausalityData>

    <a:To s:mustUnderstand="1">https://login.microsoftonline.com/RST2.srf</a:To>

    <o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">

      <u:Timestamp u:Id="_0">

        <u:Created>2015-02-02T16:45:12Z</u:Created>

        <u:Expires>2015-02-03T00:45:12Z</u:Expires>

      </u:Timestamp>

      <o:UsernameToken u:Id="uuid-27f0307e-b0bd-4b07-93e0-793c8ce94779-1">

        <o:Username>portalconnect@soneparfr.onmicrosoft.com</o:Username>

        <o:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">xxxxxxxxx</o:Password>

      </o:UsernameToken>

    </o:Security>

</s:Header>

   <s:Body>

    <t:RequestSecurityToken xmlns:t="http://schemas.xmlsoap.org/ws/2005/02/trust">

      <wsp:AppliesTo xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">

        <a:EndpointReference>

          <a:Address>urn:crmemea:dynamics.com</a:Address>

        </a:EndpointReference>

      </wsp:AppliesTo>

      <t:RequestType>http://schemas.xmlsoap.org/ws/2005/02/trust/Issue</t:RequestType>

    </t:RequestSecurityToken>

</s:Body>

</s:Envelope>

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok,

I'll try to described to you so that expert ETL advocate for using CRM via web services to integrate (add) and extract (select) data.

1- Import the definition of Web Services Dynamics CRM : Available from the following URL :

https://[company].api.crm4.dynamics.com/XRMServices
/2011/Organization.svc?wsdl

2- Authentication with Dynamics CRM 2013 Online is done through a type of authentication ' Claims- Based Identity ' : Creation of components to manage Authentication :

this web procedure is based on the connection defined in my previous post

3- After the authentification, creating a Power Module Dynamics CRM

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
[quote user="Walter75"]

Hi,

I have set up the connection between my (ETL GENIO / OTIC ) and CRM Microsoft Dynamics ( https://soneparfr.crm4.dynamics.com ) using webservices

First, I try to retrieve a GUID from the dynamics CRM with the ETL (OTIC/GENIO) interface, but I can't find witch

hosname I have to use, with wirch endpoint ?

Second part : the WSDL protterties, in the same way, witch Location and Biding to use ?

Thank you in advance,

Best Regards

[/quote][quote user="Walter75"]

Hi,

I have set up the connection between my (ETL GENIO / OTIC ) and CRM Microsoft Dynamics ( https://soneparfr.crm4.dynamics.com ) using webservices

First, I try to retrieve a GUID from the dynamics CRM with the ETL (OTIC/GENIO) interface, but I can't find witch

hosname I have to use, with wirch endpoint ?

Second part : the WSDL protterties, in the same way, witch Location and Biding to use ?

Thank you in advance,

Best Regards

[/quote][quote user="Walter75"]

Hi,

I have set up the connection between my (ETL GENIO / OTIC ) and CRM Microsoft Dynamics ( https://soneparfr.crm4.dynamics.com ) using webservices

First, I try to retrieve a GUID from the dynamics CRM with the ETL (OTIC/GENIO) interface, but I can't find witch

hosname I have to use, with wirch endpoint ?

Second part : the WSDL protterties, in the same way, witch Location and Biding to use ?

Thank you in advance,

Best Regards

[/quote][quote user="Walter75"]

Hi,

I have set up the connection between my (ETL GENIO / OTIC ) and CRM Microsoft Dynamics ( https://soneparfr.crm4.dynamics.com ) using webservices

First, I try to retrieve a GUID from the dynamics CRM with the ETL (OTIC/GENIO) interface, but I can't find witch

hosname I have to use, with wirch endpoint ?

Second part : the WSDL protterties, in the same way, witch Location and Biding to use ?

Thank you in advance,

Best Regards

[/quote][quote user="Walter75"]

Hi,

I have set up the connection between my (ETL GENIO / OTIC ) and CRM Microsoft Dynamics ( https://soneparfr.crm4.dynamics.com ) using webservices

First, I try to retrieve a GUID from the dynamics CRM with the ETL (OTIC/GENIO) interface, but I can't find witch

hosname I have to use, with wirch endpoint ?

Second part : the WSDL protterties, in the same way, witch Location and Biding to use ?

Thank you in advance,

Best Regards

[/quote]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Finally , I managed to take the step of recovering the Login Id (GUID and Security Token ) => It was just the server application ETL GENIO who had no access to the internet !

Now, I can not retrieve information via the procedure " Retrieve". Here is the debug runtime :

==> what does not work ?

<soap12_env:Body><Retrieve xmlns="http://schemas.microsoft.com/xrm/2011/Contracts/Services">
<entityName xmlns="http://schemas.microsoft.com/xrm/2011/Contracts/Services">RIBEIRO SARL</entityName>
<id>fdbe20f7-8fc1-4a4b-b5cb-f81a21200816</id>
<columnSet>

<AllColumns>true</AllColumns>

</columnSet></Retrieve></soap12_env:Body>
</soap12_env:Envelope>
INFO_TEXT:
timeout on name lookup is not supported

INFO_TEXT:
About to connect() to xxxxxxxxx.api.crm4.dynamics.com port 443 (#0)

INFO_TEXT:
Trying 157.56.199.51...
INFO_TEXT:
Connected to xxxxxxxxx.api.crm4.dynamics.com (157.56.199.51) port 443 (#0)

INFO_TEXT:
SSLv3, TLS handshake, Client hello (1):

INFO_TEXT:
SSLv3, TLS handshake, Server hello (2):

INFO_TEXT:
SSLv3, TLS handshake, CERT (11):

INFO_TEXT:
SSLv3, TLS handshake, Server finished (14):

INFO_TEXT:
SSLv3, TLS handshake, Client key exchange (16):

INFO_TEXT:
SSLv3, TLS change cipher, Client hello (1):

INFO_TEXT:
SSLv3, TLS handshake, Finished (20):

INFO_TEXT:
SSLv3, TLS change cipher, Client hello (1):

INFO_TEXT:
SSLv3, TLS handshake, Finished (20):

INFO_TEXT:
SSL connection using AES256-SHA

INFO_TEXT:
Server certificate:

INFO_TEXT:
subject: C=US; ST=California; L=Sunnyvale; O=Fortinet; OU=Certificate Authority; CN=FortiGate CA; emailAddress=support@fortinet.com

INFO_TEXT:
start date: 2008-10-18 00:46:39 GMT

INFO_TEXT:
expire date: 2028-10-13 00:46:39 GMT

INFO_TEXT:
issuer: C=US; ST=California; L=Sunnyvale; O=Fortinet; OU=Certificate Authority; CN=FortiGate CA; emailAddress=support@fortinet.com

INFO_TEXT:
SSL certificate verify result: self signed certificate (18), continuing anyway.

INFO_TEXT:
Server auth using Basic with user ''

INFO_HEADER_OUT:
POST /XRMServices/2011/Organization.svc HTTP/1.1
Authorization: Basic Og==
Host: xxxxxxxxx.api.crm4.dynamics.com
Accept: */*
Content-Length: 10076
SOAPAction: "http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/Retrieve"
Content-Type: application/soap+xml; charset=UTF-8
Expect: 100-continue

INFO_TEXT:
Done waiting for 100-continue

INFO_DATA_OUT: 10076 bytes.
Printing maximum 64 bytes.
3C 3F 78 6D 6C 20 76 65 72 73 69 6F 6E 3D 22 31 2E 30 22 20 65 6E 63 6F 64 69 6E 67 3D 22 55 54 46 2D 38 22 3F 3E 3C 73 6F 61 70 31 32 5F 65 6E 76 3A 45 6E 76 65 6C 6F 70 65 20 78 6D 6C 6E 73
INFO_TEXT:
SSLv3, TLS alert, Client hello (1):

INFO_TEXT:
Expire cleared

INFO_TEXT:
Empty reply from server

INFO_TEXT:
Connection #0 to host xxxxxxxxxx.api.crm4.dynamics.com left intact

Was this reply helpful? Yes No