Connecting postgres dataSource to API dataSource collection not found

Help me!
1

Feature(s) impacted

Observed behavior

Expected behavior

I have been able to load the API dataSource without any issue but once i attempt to make a relationship from my postgres data source to the api datasource I’m getting this error

MissingCollectionError: Collection ‘deposits’ not found. List of available collections:

below is the code that i use to make the relationship

    // Step 3: Add the one-to-many relation (from 'profilesUser' to 'deposits')
        collection.addOneToManyRelation('relatedDeposits', 'deposits', {
            originKey: 'customer_id', 
            targetKey: 'quickbooksId',
        });
    });

Failure Logs

Context

  • Project name: Ourboro
  • Team name: Customer Experience
  • Environment name:
  • Agent technology: nodejs
  • Agent (forest package) name & version: agent 1.41.11
  • Database type: postgress
  • Recent changes made on your end if any: …
2

Hello @Zero,

Could you please fill in the context template provided, it will help us troubleshoot your issue :pray:

Context

  • Project name: …
  • Team name: …
  • Environment name: …
  • Agent technology: (nodejs, php, rails, python)
  • Agent (forest package) name & version: …
  • Database type: …
  • Recent changes made on your end if any: …

What is the list of collections that the agent is reporting in the errors ? is it correct ? I assume that you already checked for typos.

Do you manage to apply other customizations to this collection ?

Thanks

@Nicolas.M

3

sorry i just made the updates to the post yes I’ve checked for typos and everything is accurate, i believe it has to do maybe with the loading of the dataSources

4

it has to do maybe with the loading of the dataSources

Do you see the expected collections from your API datasource in the frontend ? (if you go to editor mode and check for hidden collections)

If possible could you share the way you declared both datasources (the postgre on and the api ?) in your node-js agent ? You may send it in private and/or with obfuscated credentials if you must :pray:

Thanks,

@Nicolas.M