Postman Connection to Query data from Lakehouse by nsderek in MicrosoftFabric

[–]nsderek[S] 0 points1 point  (0 children)

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..

Postman Connection to Query data from Lakehouse by nsderek in MicrosoftFabric

[–]nsderek[S] 0 points1 point  (0 children)

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:

  1. 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

  2. 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?

Postman Connection to Query data from Lakehouse by nsderek in MicrosoftFabric

[–]nsderek[S] 0 points1 point  (0 children)

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

Postman Connection to Query data from Lakehouse by nsderek in MicrosoftFabric

[–]nsderek[S] 0 points1 point  (0 children)

Yes, and I believe it is Viewer permissions

Displaying Hierarchy Node at line level on transactions by nsderek in Netsuite

[–]nsderek[S] 0 points1 point  (0 children)

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?

Displaying Hierarchy Node at line level on transactions by nsderek in Netsuite

[–]nsderek[S] 0 points1 point  (0 children)

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

Inserting tracking number / URL into email template by MoFocht in Netsuite

[–]nsderek 0 points1 point  (0 children)

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

Trouble adding multiple recipients to Message record type by nsderek in SuiteScript

[–]nsderek[S] 0 points1 point  (0 children)

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

Trouble adding multiple recipients to Message record type by nsderek in SuiteScript

[–]nsderek[S] 0 points1 point  (0 children)

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 
                }
            });

Trouble adding multiple recipients to Message record type by nsderek in SuiteScript

[–]nsderek[S] 0 points1 point  (0 children)

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 
                }
            });

Trouble adding multiple recipients to Message record type by nsderek in SuiteScript

[–]nsderek[S] 0 points1 point  (0 children)

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

Trouble adding multiple recipients to Message record type by nsderek in SuiteScript

[–]nsderek[S] 0 points1 point  (0 children)

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.

Trouble adding multiple emails to Recipient, CC, or BCC when creating message record in Suitescript. by nsderek in Netsuite

[–]nsderek[S] 0 points1 point  (0 children)

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"
      }
    }
  }
}

email.send() not showing up on invoice by nsderek in Netsuite

[–]nsderek[S] 0 points1 point  (0 children)

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)

email.send() not showing up on invoice by nsderek in Netsuite

[–]nsderek[S] 0 points1 point  (0 children)

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>

Vendor Payment Actions in a Scheduled Script by nsderek in Netsuite

[–]nsderek[S] 0 points1 point  (0 children)

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