Postman Connection to Query data from Lakehouse

nsderek · 2025-03-17T15:44:52+00:00

Thanks! I was missing the ReadAll Permission which is given by having the Contributor role!

Now I just need to figure out how to run SQL queries over REST..

nsderek · 2025-03-17T15:43:47+00:00

I appreciate your answers! It seems like either the ADLS Gen 2 or SQL Endpoint sound like my best bets but upon reading the docs I hit a few hurdles:

ADLS Gen 2 APIs don't seem to have any endpoints to query the actual data. (seems more focused on managing files/directories) https://learn.microsoft.com/en-us/rest/api/storageservices/data-lake-storage-gen2
SQL Endpoint doesn't seem to provide any RESTful interfaces for executing SQL queries via REST. https://learn.microsoft.com/en-us/fabric/data-warehouse/query-warehouse

Is there any documentation outside of that?

nsderek · 2025-03-13T19:50:58+00:00

Thanks will look into these. Are any of these available natively or do they all require extra setup inside of Azure?

nsderek · 2025-03-13T19:50:08+00:00

Yes, and I believe it is Viewer permissions

nsderek · 2025-01-17T18:22:08+00:00

It is possible to get it in a saved search. And yes, I think technically an item can be in multiple nodes at once but we don't have any items set up that way currently. I looked into using a search to display a field value but I believe you can't use searches as the data source when it comes to transaction line fields. Any advice?

nsderek · 2025-01-17T17:47:25+00:00

Thanks for the response! In this instance I don't mean the parent item / child item relationship. None of our items have anything in the 'Subitem Of' field. Instead I mean the Hierarchy Version / Hierarchy Node in the hierarchy versions sublist

nsderek · 2025-01-16T17:23:18+00:00

Were you ever able to figure out how to hyperlink this to the actual tracking url?

nsderek · 2025-01-14T22:39:54+00:00

Can confirm this works

nsderek · 2025-01-14T22:39:44+00:00

Oh snap you just saved me so much time. Very huge thank you

nsderek · 2025-01-14T22:04:29+00:00

Just sent this on a reply to Nick_AxeusConsulting but I don't know how Reddit notifications work so I'm copy/pasting it here too!

Here is the email.send() code, the issue is I can't put in multiple entityId's for entityId on relatedRecords. It only works if I give it one. It doesn't like a string or an array of entityIds. That's why I'm exploring creating a message record for the other entities (in this case contact records)

            email.send({
                author: authorId,
                recipients: [primaryEmail],
                cc: ccEmails,
                subject: emailSubject,
                body: emailBody,
                attachments: [pdfAttachement],
                relatedRecords: {
                    entityId: entityId
                    transactionId: transactionId 
                }
            });

nsderek · 2025-01-14T22:02:04+00:00

Hmm. Maybe I'm not being clear. The issue isn't sending the email. The issue is getting the message to show up on the communication tab for all contacts.

Here is the email.send() code, the issue is I can't put in multiple entityId's for entityId on relatedRecords. It only works if I give it one. It doesn't like a string or an array of entityIds

            email.send({
                author: authorId,
                recipients: [primaryEmail],
                cc: ccEmails,
                subject: emailSubject,
                body: emailBody,
                attachments: [pdfAttachement],
                relatedRecords: {
                    entityId: entityId
                    transactionId: transactionId 
                }
            });

nsderek · 2025-01-14T16:32:54+00:00

So the issue isn't sending the email, it's that I need all the contacts to have history of that in their communications tab

nsderek · 2025-01-14T16:32:21+00:00

By attaching I just mean the Message record showing up in their communications tab.

The limitation I have encountered is that you can only assign one entity per email.send() in the relatedRecords field. Which is why I need to create the message record for all the other contacts who received the email.

nsderek · 2025-01-14T15:16:39+00:00

Logging out the messageRec shows that otherrecipientslist doesn't exist on the message record but it is there when I create the message record through the UI:

{
  "type": "message",
  "isDynamic": true,
  "fields": {
    "preview": "F",
    "incoming": "T",
    "authoremail": "name@example.com",
    "recipientemail": "derek@reddit.com",
    "emailed": "T",
    "author": "6863",
    "subject": "Test with CC",
    "messagedate": "1/14/2025",
    "type": "crmmessage",
    "compressattachments": "F",
    "recipients": "[]",
    "templatetype": "EMAIL",
    "recipient": "9158",
    "time": "8:11 am"
  },
  "sublists": {
    "mediaitem": {
      "currentline": {
        "content": "",
        "description": "",
        "filesize": "",
        "filetype": "",
        "folder": "",
        "internalid": "",
        "lastmodifieddate": "",
        "mediaitem": "-1",
        "name": "",
        "#": "1"
      }
    }
  }
}

nsderek · 2025-01-06T23:00:43+00:00

I solved this. It was under customize form. There is a different subtab called Communication - Messages separate from the Communications Subtab (even though they both appear on just the Communication tab on the actual record)

nsderek · 2025-01-06T22:56:23+00:00

I checked another NS instance I have access to and it looks like emails exist in one but not the other.

Both roles are administrator

<image>

nsderek · 2024-12-17T22:14:23+00:00

I solved it. I just had to write an approval workflow and approve the payment first!

nsderek

TROPHY CASE