How do I then use the linkedPulseIds to pull my related Jobs? Can this be done in a single query or do I need some scripting to dig into the JSON, grab the IDs, then run another query?
@chadhutchins10
I always iterate through the linked pulse ids to get the details of the jobs. I don’t know of a way to include the linked pulse id information in the graphql call.
Sometimes I’ve had luck with adding mirror columns on the other board, if you just need 1 column. (it will come across as a different column, but this seems to be inconsistent from the API) so I almost always just end up iterating through the linked pulseIds.
maybe someone else has a more efficient method, as I’m sure thats not the answer you were hoping for.
@basdebruin I’ve noticed the Item ID column type, despite what the documentation says, can be be used to search for a pulse. While this is silly since you have to have the pulse id to start with - I use it in integromat/make to get a single item and specify the columns i want values for. Because for some reason, the get item column value module only gets one column value but there is no module to get multiple columns from an item by item id (pulse id).
However the “get an item” module returns all columns. When I dont need all the columns - especially mirror columns, that is a lot of extra latency and query complexity. If I only need two or three columns, i can use the search.
That said, I’m working on transitioning my work to AWS Lambda, so I can optimize the snot out of things with multiple operations in a single call (for example).
Get an Item does not provide any ability to specify columns (in Make.com at least, which is replacing integromat and you can’t sign up for new integromat accounts), and always returns all columns in my experience.
If the link between the two boards is bidirectional:
Instead of searching the Customer ID in the Job Board (search item in board by column value), you can get the the item of the desired Customer in Customer Board and read all related Job-IDs