Forum Discussion

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
6 years ago
Solved

URL link changes capital letters to regular ones after loading Power Query. Why?

Hello everyone,   I have a report which takes data from Salesforce. Each Opportunity has its own URL like: https://mycompany.my.salesforce.com/00abC   I've encountered one case where two Opportu...
Need Help
AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
6 years ago

Hi Rob,

I ended up creating a new column using a basic

CONCATENATE("https://YOURCOMPANY.my.salesforce.com/", [Opportunity  Internal ID])

Salesforce was pretty clever - the internal ID of an opp is also its link.

Hopefully it works for you too.

Alice

zelroberic's avatar
zelroberic
Frequent Visitor
6 years ago

Hi Alice.

Ok this makes sense.

I am actually in an Invoice table and it appears that the ID also has letters in it. I will speak to our Sales Force administrator to get more clarity. Thanks for getting back to me so fast. I don’t under why this issue doesn’t come up a lot when pulling information from the web.

 

Thanks Rob

  • AliceW's avatar
    AliceW
    Icon for Power Participant rankPower Participant
    6 years ago

    Cool, you have invoicing in Salesforce! I think the logic behind the 'Internal ID' is the same. I know I use it for Leads too.

    • zelroberic's avatar
      zelroberic
      Frequent Visitor
      6 years ago

      We import our invoices from NetSuite our ERP system so our Sales people can have access to their Sales and Orders.

      Interesting I didn't see the field [Operational Internal ID] at first glance. I will look again. The [ID] field I saw still contained 

      letters. The internal ID is totally numeric? 

      Thanks for your help so far. I really appreciate it.

      Rob

      • AliceW's avatar
        AliceW
        Icon for Power Participant rankPower Participant
        6 years ago

        Hi Rob,

        The internal ID is (for us) a combination of letters and numbers, such as 0063MX90004qzCN. The field is definitely there, as it's used by Salesforce as an unique identifier for a particular record (Opps, Accounts, Users etc.). It should have 'internal' in the name. Your IT department should have made it visibile though (or perhaps it's just me) 🙂

        Good luck!

        Alice