3 Replies Latest reply: Apr 1, 2016 9:14 AM by Bertil Palmqvist RSS

    SalesForce connector limited extract

    Thomas Le Gall

      Hello Everyone,

       

      I am facing an issue with the SalesFoce Connector on the "Event" table :

      Only an avg of 5### rows are loaded, versus >30000 in SalesForce.

       

      And it seems this appears only for this table. I do not use any "where" clause.

       

      QV Desktop:  11.20.12904.0 SR12 64-bit

      SalesForce Connector : Qlik SalesForce Connector Version 13.1.0.5 publisher QlikTek

       

      Did anyone already face this issue ?

       

      Any help would be appreciated,

      Tanks

       

      Thomas

        • Re: SalesForce connector limited extract
          Bertil Palmqvist

          Hi Thomas,

          This Problem seems to be like one I had myself.

          Recently I heard that some tables in Salesforce are archived by Default, among them Event.

          The Solution in the Connector is to change the parameter QueryMode from Query to QueryAll. That causes the Query to fetch all Records from Event, also archived and deleted. It did the Trick for me.

           

          I hope this will help You too.

           

          Best Regards

          /Bertil

            • Re: SalesForce connector limited extract
              Thomas Le Gall

              So, Yes sorry I had the answer: this is a non-QV issue.

              SalesForce has an auto-archived function. When you load data from other ways SF knows it has to search in archived tables. But connector load only actual non-archived data.

               

              My customer asked SF to get in this "event" table an history of #Years.

               

              Your solution seems better.

               

              Thanks,

              Thomas

                • Re: SalesForce connector limited extract
                  Bertil Palmqvist

                  Your right. This is a Saleforce issue but You can actually deal with it in the Connector.

                  To the Salesforce API you can send the parameter ”ALL ROWS" to fetch all rows. That parameter is what QueryAll sends to the API from the Connector.


                  I didn't know about this auto-archive function i Salesforce until just the other Day. Our Salesforce consultant knew about it and the parameter. He also told that the function by default archives records older than one Year but that You can change that somewhere in the Settings. We have older than 3 Years.


                  All the Best

                  /Bertil