Google Sheets - Make an API Call - Error

How To
, ,
1

Hi Makers!

Wondering if anyone has any experience with the following:

I am using an APIFY module that scrapes Indeed for jobs using certain keywords. And am looking to convert those bundles of data into an array (using the Text Aggregator; input in photo) - I then create a google sheet and format it (which are the modules behind the Text Aggregator input popup window) - and then we get to the ‘Google Sheets - Make an API Call’ module - which is where I’m having errors (which is the second screenshot below; the error screen).

image
image1686×760 94.3 KB

My G.Sheets API Call Module Inputs:

image
image460×600 28.5 KB

image

This execution errored processing 50 bundles - but has been successful processing 5 bundles (as I’ve been testing it; hoping to ramp up to 100 bundles in a single execution).

image
image473×663 36.7 KB

I also just tried 15 bundles and got this error message:

image
image478×554 27.4 KB

Any ideas would be appreciate. Wish you all the best.

Pat

3

Looks like you are including the square brackets [] once in the Text Aggregator, then another time in the Sheets module. Is this intentional?

If you need further assistance, please provide the following:

Please provide the input and output bundles of all the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

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

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles 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 input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like
4

Hi @Pat_Shantz

This error is due to an incorrect JSON payload. You can validate your JSON in JSON editors available in online. Or build a proper JSON using the JSON module “Create JSON”.

Then map it to the Google Sheet module…
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel