Lookup/Query Salesforce Contracts & Contract Line Items
I wonder whether you can help me with the following or at least point me in the direction of some documentation please. I’m using the Salesforce connector which as I understand it (but correct me if I’m wrong) is written and supported by Scribe?
I’ve successfully created maps for Opportunities and Orders with related data to include Line Items for each record type. I’m now trying to do Contracts in the same manner but the connector doesn’t appear to support related data for this record type and I’m struggling to figure out a solution here. On the “Include” screen, I can’t see anything for Contract Line Items like I can for Opportunities...
Without the data here – it means I can’t use the For Each Child block. I noticed that the connector has a separate end point called “ContractLineItems” so I set up a map to query this and retrieve the Line Items for each Contract ID within a loop. But then I came across a blocker for how I then loop over the results of the Line item call…
• The For Each Child block doesn’t work after a Lookup Block, I can’t select anything in the Entity picklist
• A For Each Result block has what I’ll call two “connection points” at the bottom of the block, so I can’t use that after a Lookup Block as it only expects a block with one connection point
My last ditch attempt was to try a loop block, which as I understand from the Scribe Knowledge Base acts like a “Do-While-X-Meets-A-Condition” and needs a Loop Exit but that’s as far as I got – is this what I need use? If so, how do I tackle this please?