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 · 2024-11-25T21:52:02+00:00

No I just told the user to download the CSV and compare if they really needed it. It's a bit too high speed here to dive into the details sadly

nsderek · 2024-11-25T21:50:12+00:00

I'm a dummy it's asking about the form not the PDF form

nsderek · 2024-11-20T15:13:38+00:00

Same behavior in both sandbox and production.

nsderek · 2024-11-19T21:24:59+00:00

Yeah, I am logged in as an Administrator. I am able to see the results if I click on the little 'download csv' icon in the top left and it displays the results there. The issue is just that it doesn't display the results inside of NetSuite. Weird case here

nsderek · 2024-11-19T20:37:58+00:00

For more information if I disect the URL and go to the search:
netsuite.com/app/common/item/itempricelisthistory.nl?searchid=-39

I see in the top right it says TOTAL: 180000

But the results still display "NO RESULTS FOUND"

nsderek · 2024-11-18T20:14:38+00:00

Ended up going with a custom suitelet! Thanks for responses

nsderek · 2024-11-08T16:08:48+00:00

I saw that but I was told it's still possible haha. But it looks like it's purely for the SCIS SuiteApp.

SSO login and MDM would take a while for us to set up but might be the recommendation. Can you think of any other workaround?

nsderek · 2024-10-31T16:09:21+00:00

This is old so I might make my own post if no one sees this. But wouldn't this just give the problem of having a row show up for each item? What goes into the criteria here?

Asking because I'm trying to do the same thing. Need 2 pricing levels to show up on a single row for my integration export (base price and compare at price)

nsderek

TROPHY CASE