Replacing SOQL relationship query with eloquent about eloquentsalesforce HOT 5 OPEN

Some things to note first:

1. You do not need to include use ... SOQLBuilder; - this is already part of the model.
2. You should not need to include use App\SalesforceModels... when used in a model that already exists there.
3. Your opportunity model is referencing Opportunity__c - assuming you are trying to access the standard SFDC Opportunity table, you do not need to use __c and thats probably why you're getting the "resource not found error"

from eloquentsalesforce.

@roblesterjr04 1 and 2 I'll remove the extra code
3. Opportunity__c is the correct model. It is a custom table not the standard table

I'm wondering how to access the relations. It works with an SOQL query and it works by using dot notation and nested selects inside the $columns variable. but it does not work using belongsTo belongsToMany

from eloquentsalesforce.

Thats really weird, i use relationships all over the place in my own use, haven't experienced this.

from eloquentsalesforce.

My guess is you probably need to add the foreign keys to the relationships, and make sure any associated foreign/primary keys are included in your column selections.

For example, here's a model I used. I had to specify which column i was using as the foreign key.

<?php

namespace App\SalesForce;

use Lester\EloquentSalesForce\Model;

class AccountTeamMember extends Model
{

    public function account()
    {
        return $this->belongsTo(Account::class, 'AccountId');
    }

}

Where AccountId is the column on AccountTeamMember that references the Id on the Account object.

This is standard Eloquent relationship practice if the column IDs can't be assumed by the framework, which rarely works on Salesforce tables.

from eloquentsalesforce.

Oh I see whats happening now - you're specifying columns, and when you do that, you're basically causing the relationship columns not to be selected, and they are needed. Make sure you are adding those relationship ID columns to the $columns array.

from eloquentsalesforce.