HTTP Request In make

[Darren_Murphy]

Okay, so that’s all good.
That means there must be something wrong with the configuration in Make.

[mwza]

Will keep you posted when i discover what! thanks darren

[mwza]

After all that! My bad - sorry to have wasted time - simply did not have the word “Bearer” preceding my key!

[ThinhDinh]

Haha so I was correct in seeing a seemingly shorter version of what I usually see.

[mwza]

As always - thank you for involvement on this community!

[mwza]

I have one last requirement that am battling to make work - I want the attachment that comes with the xero invoice to be added as a link in glide (for users to be able to view).
Here is what the Xero get an invoice includes:

Any guidance as to how i might achieve that?

[Darren_Murphy]

You can push that back to Glide via the API using the set-columns-in-row kind.
You will need the RowID of the affected row, but presumably you already have that from the original webhook?

[mwza]

Do you mean as a separate and additional operation to the HTTP request that is creating the row
in Glide?

[Darren_Murphy]

It could be in the same request, if it belongs in the row that you’re adding.

[mwza]

Hi All
Revisiting my HTTP request in a Make Scenario, to get records from a user table in Glide.
The Scenario is triggered with a custom mailhook which obviously returns the sender’s email address.
What I am trying to do now is an HTTP request to get the user record from the user table by filtering the Get records request on the sender’s email.
My request is working but returning all user records, not just the sender’s record.
I have tried the following:

{
  "appID": "{{correctAppID}}",
  "queries": [
    {
      "tableName": "{{native-table-correctTableName}}",
      "utc": true,
      "options": { "Email": "{{2.from.address}}"
}   
 }
  ]
}

and

{
  "appID": "{{correctAppID}}",
  "queries": [
    {
      "tableName": "{{native-table-correctTableName}}",
      "utc": true,
      "Email": "{{2.from.address}}"
}   
 }
  ]
}

but cannot get only the one record returned.
Appreciate any advice as to how to achieve returning only the user record that matches the sender’s email.
I have double checked user record exists and my user tables email column is called “Email”.
Thank you

[Darren_Murphy]

@mwza

Appreciate any advice as to how to achieve returning only the user record that matches the sender’s email.

Not possible.
Filtered API queries are only supported with Big Tables, and the User Profiles table cannot be a Big Table.

You will need to do the filtering inside Make.

[mwza]

Thanks Darren