2 Replies Latest reply on Sep 5, 2017 3:04 PM by Aaron Zhang

    datasource id and connection id issue, API 2.4

    Aaron Zhang

      Hi There,

       

      I'm trying to link the datasource with workbook using SOAP API 2.4.

      The 2 API I'm using is:

      Query Workbook connection, which returns the workbook and connection relationship.

      And

      Query Datasource connection, which returns the datasource and connection relationship.

       

      But what wield is that even I know that a connection in a datasource is used by a certain workbook, but the 'connection's id'(GUID) in the workwork and datasource are totally difference.

      snapshot.png

      But how can I link the workbook and datasource if their connection id is different?

       

       

      -Thanks,

      Aaron

        • 1. Re: datasource id and connection id issue, API 2.4
          Glen Robinson

          Hi Aaron

          I have tried the same with API 2.7 and get the following results. (I dont know if  you get the same results with 2.4, as I cant test on this version)

           

          Using Query Workbook Connections, I get the following XML response (which is showing the Published Data Source details

           

          <tsResponse>

            <connections>

              <connection id="c8789f0c-8ddd-442f-a9b6-fe3d6346cb6d"

                 type="sqlproxy"

                 serverAddress="localhost"

                 serverPort="8080"

                 userName="">

                 <datasource id="cf5d91df-6ec1-4027-ae68-6e30f22f2a1d" name="World Indicators" />

               </connection>

             </connections>

          </tsResponse>

           

          Hope this helps

          Glen

          • 2. Re: datasource id and connection id issue, API 2.4
            Aaron Zhang

            Hi Glen,

             

            Thanks a lot for the testing.

            I'm using the same API in 2.4 and able to get the source information for the workbook as following:

            (Using 'Query Workbook Connections')

            1.png

            Meanwhile I'm using the API of 'Query Datasource' and try to match them with previous result. But what wield is neither the id or the name can be matched....

             

            -Thanks,

            Aaron