Please be sure of your agent type and version and pick the right documentation accordingly.
This example shows you how to create a smart collection to list the companies of your Hubspot account.
const collection = require('forest-express-sequelize');
collection('hubspot_companies', {
isSearchable: true,
fields: [
{
field: 'id',
type: 'Number',
},
{
field: 'name',
type: 'String',
},
{
field: 'hubspot_link',
type: 'String',
},
],
});
const Liana = require('forest-express-sequelize');
const express = require('express');
const superagent = require('superagent');
const JSONAPISerializer = require('jsonapi-serializer').Serializer;
const router = express.Router();
// define the serializer used to format the payload
const hubspotCompaniesSerializer = new JSONAPISerializer('hubspotCompanies', {
attributes: ['name', 'hubspotLink'],
keyForAttribute: 'underscore_case',
id: 'companyId',
transform(record) {
record.name = record.properties.name.value;
record.hubspotLink = `https://app.hubspot.com/contacts/6332498/company/${record.companyId}`;
return record;
},
});
function getHubspotCompaniesList(limit, offset) {
return superagent
.get(
`https://api.hubapi.com/companies/v2/companies/paged?hapikey=${process.env.HUBSPOT_API}&properties=name&limit=${limit}&offset=${offset}`
)
.then((response) => JSON.parse(response.res.text));
}
async function getAllHubspotCompanies() {
let allHubspotCompanies = [];
let hasMore = true;
let offset = '';
while (hasMore) {
let getCompaniesResponse = await getHubspotCompaniesList(250, offset);
allHubspotCompanies = allHubspotCompanies.concat(
getCompaniesResponse.companies
);
offset = getCompaniesResponse.offset;
hasMore = getCompaniesResponse['has-more'];
}
return allHubspotCompanies;
}
function searchHubspotCompanies(companies, search) {
return companies.filter((item) => {
return item.properties.name.value
.toUpperCase()
.includes(search.toUpperCase());
});
}
router.get(
'/hubspot_companies',
Liana.ensureAuthenticated,
async (req, res, next) => {
// set pagination parameters when exist (default limit is 250 as it is the max allowed by Hubspot)
let limit = req.query.page ? parseInt(req.query.page.size) : 20;
let offset = req.query.page
? (parseInt(req.query.page.number) - 1) * limit
: 0;
// set search terms when exist
let search = null;
search = req.query.search ? req.query.search : search;
let hubspotCompanies = await getAllHubspotCompanies();
if (search) {
hubspotCompanies = searchHubspotCompanies(hubspotCompanies, search);
}
const count = hubspotCompanies ? hubspotCompanies.length : null;
const paginateHubspotCompanies = hubspotCompanies.slice(
offset,
offset + limit
);
const serializedCompanies = hubspotCompaniesSerializer.serialize(
paginateHubspotCompanies
);
return res.send({ ...serializedCompanies, meta: { count } });
}
);
module.exports = router;