JSforce query call not returning

jsforce

I'm trying to prove out a basic JSforce library use case in Node.js. I'm able to connect to Salesforce, but for some reason, I'm unable to run a basic query.

Node version: v16.13.0
jsforce version: 1.10.1
OS: Windows 10 Enterprise version 1909

Repro code:

import jsforce from "jsforce";
import dotenv from "dotenv";
let SF_USERNAME, SF_PASSWORD;

const runTest = async () => {
  dotenv.config();
  ({ SF_USERNAME, SF_PASSWORD } = process.env);

  // Outputs my username correctly
  console.log("SF_USERNAME: " + SF_USERNAME);

  const config = { loginUrl: "https://test.salesforce.com" };
  const conn = new jsforce.Connection(config);
  await conn.login(SF_USERNAME, SF_PASSWORD);

  // Outputs my user ID correctly
  console.log("Authenticated User ID: " + conn.userInfo.id);

  // When I uncomment the 3 lines below, my terminal freezes indefinitely
  // const { totalSize, records } = await conn.query(
  //  "SELECT Id, Name FROM Account LIMIT 3"
  // );
};

runTest();

I'm using $ node src/test.js in Git Bash to execute this. I have also tried using the old CommonJS syntax (i.e. const jsforce = require("jsforce");) and running the code as a CommonJS script, with the same results.

It all seems straightforward enough. What am I doing wrong?

Best Answer

@identigral had a good guess, and that StackOverflow article seemed like it might be on to something. But in the end, the root cause was something less obvious.

This root problem turned out to be that my Salesforce password had expired (the audience groans). Once I reset my password, everything (including the async/await syntax in my sample code) started working just fine.

Related Solutions

[SalesForce] Invoking metadata API call using JSFORCE

From the metadata documentation for the retrieve call in SFDC, metadata requires any of the below.

Package name or list of packages you want to retrieve the metadata info for
A package.xml consisting of the list of file names to retrieve

I guess in your case you should create a retrieve Request object which will be pointed to the package.xml file.

The working code is as below.

<apex:page applyHtmlTag="true">
    <apex:includeScript value="{!$Resource.Jsforce}"/>
    <input type="file" id="input"></input>
    <script type="text/javascript">
        function ctrlRead(){
            var selectedFile = document.getElementById('input').files[0];
            var files = selectedFile.files;
            var para = {apiVersion:37.0,singlePackage:false,unpackaged:files};
            var conn = new jsforce.Connection({ accessToken: '{!$Api.Session_Id}'});
            conn.metadata.retrieve(para,function(error,ref) {
                if (error) {
                    console.log("error");
                }
                else {
                    console.log(JSON.stringify(ref));
                }
            });
        }
    </script>
    <apex:form >
        <div>DEPLOYMENT TOOL</div>
        <apex:commandButton onclick="ctrlRead();" value="Reterive" id="theButton"/>
    </apex:form>
</apex:page>

[SalesForce] jsforce Bulk API query is not returning records in proper json format

I was able to get proper json formatted records from Bulk API by formatting raw records that jsforce is emitting. I used csvtojson library to listen to the stream that jsforce is returning and parsing each row as json.

Once I set flatKeys and checkType properties to false and true respectively, I am getting data in the format I need and easy to work with. Hope others find this useful.

// JSForce
const jsforce = require("jsforce");
const csv = require("csvtojson");

let conn = new jsforce.Connection({
  accessToken:
    "<paste access token here>",
  instanceUrl: "https://abc.my.salesforce.com",
});

conn.bulk.pollInterval = 1000;
conn.bulk.pollTimeout = Number.MAX_VALUE;
let records = [];

(async () => {
  // We still need recordStream to listen for errors. We'll access the stream
  // directly though, bypassing jsforce's RecordStream.Parsable
  const recordStream = conn.bulk.query(
    "SELECT Id, FirstName, Profile.Name, IsActive FROM User WHERE Profile.Name = 'System Administrator' LIMIT 2"
  );
  const readStream = recordStream.stream();
  const csvToJsonParser = csv({flatKeys: false, checkType: true});
  readStream.pipe(csvToJsonParser);

  csvToJsonParser.on("data", (data) => {
    records.push(JSON.parse(data.toString('utf8')));
  }); 

  new Promise((resolve, reject) => {
    recordStream.on("error", (error) => {
      console.error(error);
      reject(new Error(`Couldn't download results from Salesforce Bulk API`));
    });

    csvToJsonParser.on("error", (error) => {
      console.error(error);
      reject(new Error(`Couldn't parse results from Salesforce Bulk API`));
    });

    csvToJsonParser.on("done", async () => {
      resolve(records);
    });
  }).then((records) => { 
    console.log(records);
  });
})();

This prints the below output:

[
  {
    Id: '005abc',
    FirstName: 'John',
    Profile: { Name: 'System Administrator' },
    IsActive: false
  },
  {
    Id: '005def',
    FirstName: 'Robert',
    Profile: { Name: 'System Administrator' },
    IsActive: false
  }
]

Best Answer

Related Solutions

[SalesForce] Invoking metadata API call using JSFORCE

[SalesForce] jsforce Bulk API query is not returning records in proper json format

Related Topic