Salesforce API call

How To
, ,
1

Hello community,

Wanted to see if I could get some help
I am trying to retrieve a salesforce dashboard report using the salesforce api call from make.com, but I always get this error: [404] The requested resource does not exist

I did setup https://.my.salesforce.com/services/data/v60.0/analytics/dashboards/00O3g0000017mKKEAY

and I followed the site:

but I keep getting an error any help?
I have already tried the pre defined calls on salesforce and for none of them can I get a “Feed” of all cases created in a specific queue or I cant query the report I just get the report ID and I want to be able to track the queue or call the report results a couple of times a day.

2

Welcome to the Make community!

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes
3

Hey @ozkar521 - Are you still having issues with this? I’d be happy to try and help troubleshoot.

From what I can tell from your original message, it looks like your salesforce url isn’t correct, hence why you’re getting the 404 error as it cannot find the page you’re looking for.

In your link you provided, did you purposely take out your salesforce tenant name for security reasons? Your link should look something like https://{your_salesforce_tenant_name}.my.salesforce.com/services/data/v60.0/analytics/dashboards/00O3g0000017mKKEAY

If you did, then we’ll have to dig a little deeper. Another tip is to use Salesforce inspector chrome plugin in your salesforce interface to help you confirm the path / resource ID and what not.

Let me know how I can be of help and we can go from there!

4

I tried that and this is what I found on the chrome developer tools:
https://intellishift.lightning.force.com/aura?r=30&ui-analytics-reporting-runpage.ReportPage.runReport=1

Origin:
https://intellishift.lightning.force.com
Referer:
https://intellishift.lightning.force.com/lightning/r/Report/00O3g0000017mKKEAY/view?queryScope=userFolders

input
[
    {
        "url": "https://intellishift.my.salesforce.com/services/data/v60.0/analytics/reports/00O3g0000017mKKEAY/describe",
        "method": "GET",
        "headers": [
            {
                "key": "Content-Type",
                "value": "application/json"
            }
        ]
    }
]

I tried this as well:

(https://intellishift.lightning.my.salesforce.com/services/data/v60.0/analytics/reports/00O3g0000017mKKEAY/describe)

5

@ozkar521 Can you export your blueprint or provide some screenshots as to what modules you’re using to try and accomplish this?

There are a few different ways to go about this from using the get action within the salesforce module to making a custom API call. It seems as though you’re using the custom api call action but I just want to confirm prior to making a few recommendations.

6

yes thank you workflowsy!!
blueprint.json (5.2 KB)

7

I think you just gave me an idea.
I searched a case and was able to find the recordType id I was looking for… and I want to setup a feed so that I can monitor this and see what cases come in… I just wish there was an easier way and thought maybe doing the report meta data.

8

There are a few ways you could do this. The easiest way would probably be to set your flow to run on a scheduled cadence. For the sake of example, let’s say every hour. Now what you could do is set it to search for records of a certain type as you indicated, but only have it search (via filter) for stuff that has been created within the last hour so you’d only ever see “new” results from the time you ran your last execution to when you run your next execution.

It doesn’t look like salesforce has any event driven way to do this in Make, however I know salesforce does have an event bus that if you really wanted to get records real time as they’re created that could be setup, but would likely require some additional configuration outside of make.

Let me know if this helps accomplish what you’re going for or if I could help further

2 Likes
9

yeah I am going to go the route of calling like you said every couple of hours our Queue doesnt change that much, it will then first aggregate I think and then compare against the google drive sheet and just update the fields if it already exists if not to add a record I guess… and set a limit of like 100 which I dont think we ever have that many cases …

on another note is there a way to retrieve case activity?