[SalesForce] How to call Standard REST service in POST request using JSforce

I am using JSforce, a module of Node.js for Salesforce. The login credentials are obviously not correct in this script but they are correct in original script and they are working fine. Here is app.js

var http = require('http');
var express = require("express");
var app = express();
var jsforce = require('jsforce');
var conn = new jsforce.Connection({
oauth2 : {
// you can change loginUrl to connect to sandbox or prerelease env.
loginUrl : 'loginURl',
clientId : 'client_id',
clientSecret : 'secret_id_35686',
redirectUri : 'localhost:4000/'
}
});
var username = 'username';
var password = 'passowrd';
app.set('view engine', 'pug');
//body to be sent for post
var body = {
Auth0__Id: 'test_id',
us__c : 'Pending – New Hire',
Recope : '012F0000001E1lvIAC',
};
conn.login(username, password, function(err, userInfo) {
if (err) { return console.error(err); }
app.get('/forms', function(req, res){
res.render('form.pug', { check : conn.accessToken });
});
// this is where the problem is in my opinion
var options = {
'Content-Type': 'application/json'
};
conn.apex.post(conn.instanceUrl +"/services/data/v36.0/sobjects/SFDC_Employee__c/", body, options, function(err, res) {
if (err) { return console.error(err); }
console.log("response: ", res);
});
});
app.set('port', process.env.PORT || 4000);
app.listen(app.get('port'));

Here is the link to JSforce Post Apex Instructions https://jsforce.github.io/jsforce/doc/Apex.html#post.
Here is the example of JSforce with Apex Rest API.
https://jsforce.github.io/document/#apex-rest

Is it necessary for me to include "options" parameter for defining metadata and headers? If yes! How can I do it? I think I am not defining it the right way?.
When I run this script I get this error.

{ [NOT_FOUND: The requested resource does not exist] name: 'NOT_FOUND', errorCode: 'NOT_FOUND' }

Best Answer

SFDC has two ways of exposing REST API

1)Custom apex Built

2)Standard REST API

You are trying to use JSForce for apex built while your endpoint is of Standard REST API .

Use the below for standard REST API to create records

// Single record creation
conn.sobject("SFDC_Employee__c").create({
Auth0_Id__c: 'sfnewcheckst_d',
Status__c: 'Pending - New Hire',
RecordTypeId: '012F00000lvIAC'
}, function(err, ret) {
  if (err || !ret.success) { return console.error(err, ret); }
     console.log("Created record id : " + ret.id);
   // ...
 });

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] Inserting a record with a Master-Detail type field into a custom object using JSforce

Your logic should be:

Query the Salesforce Id of Parent (Person__c is its a custom object) record from DataBase using SOQL.
- Create using create operation if it does not exists, you would get Salesforce Id back.
Create Child (Email__c if its a custom object) record passing the lookup Id from above step.

Tried to add a psuedo code based on your requirement:

var records = [];
var accountRecordId = '';

// query the Account matching the name
conn.query("SELECT Id, Name FROM Account WHERE Name = 'Test Account' LIMIT 1", 
function(err, result) {
    if (err) { 
        return console.error(err); 
    }
    console.log("total : " + result.totalSize);
    console.log("fetched : " + result.records.length);

    if(result.records.length > 0) {
        accountRecordId = result.records[0].Id;
    }
});

if(accountRecordId == null) {
    // Create Account if it does not exists
    conn.sobject("Account").create({ 
        Name : 'Test Account' 
    }, function(err, ret) {
        if (err || !ret.success) { 
            // handle exception
            return console.error(err, ret); 
        }
        accountRecordId =  ret.id;
    });
}

// at this point we have accountRecordId populated


// Create child contact, use the Salesforce Account Id as a key for AccountId field
conn.sobject("Contact").create({ 
    LastName: 'Contact Name',
    AccountId: accountRecordId 
}, function(err, ret) {
    if (err || !ret.success) { 
        // handle exception
        return console.error(err, ret); 
    }
    console.log("Created record id : " + ret.id);
    // ...
});

Related Topic

[SalesForce] Call to REST API works in CURL but not with Node app