Forum Discussion

mikeandrews's avatar
mikeandrews
New Contributor III
8 years ago

Integrating with REST APIs + OAuth when no native Snap is available

Hi, I’m looking into some API integrations with some services that are not supported by native snaps, but do offer a rich REST API and support OAuth. The wiki docs on the REST Snap have some deta...
JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago

Hi @SL12345 ,

Have you tried putting a groupByN snap behind it and as target field $Cars.

Regards

Jens

SL12345's avatar
SL12345
New Contributor III
4 years ago

I need to correct my question … every JSON should have header “Cars”

{
	"Cars":
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "BMW",
  "Year": "2020",
  "Fuel": "Petrol"
}
,
{
  "Cars" :
{
  "CompanyName": "TestCompany",
  "CompanyAddress": "TestAddress",
  "Brand": "Jaguar",
  "Year": "2020",
  "Fuel": "Diesel"
}
}
  • Siva_Venna's avatar
    Siva_Venna
    Contributor
    6 years ago

    Thanks @Spiro_Taleski @jcampion
    For now I have used mapper snap and it worked.
    In the mapper I have created(tablename+year) - abc_Date.now().getFullYear() - $tablename
    Instead, if I create only date part as variable Date.now().getFullYear() - $year How to pass this in table name filed in Select snap?
    Table name = ‘abc_’+$year ?

    • jcampion's avatar
      jcampion
      New Contributor III
      6 years ago

      Hi @Siva_Venna,
      I think that would work. It seems like there’s a bug in the SQL snap’s expression evaluation where it’s choking on Date.now(), but if you already have the $year field I would think you can use ‘abc_’ + $year to get the tablename. Give it a try!

      • Judy
      • Siva_Venna's avatar
        Siva_Venna
        Contributor
        6 years ago

        I gave a try it did not work. Hope the fix will resolve the issue.