REST Metadata

  • 103Views
  • Last Post 23 March 2020
0
votes
Joshua Harvey posted this 15 January 2020

Trying to setup a source connection via REST Api using a GET request from Callrail's /calls.json endpoint and unsure what needs to be included in the Metadata field. I know it's standard JSON format. Also having issues with the Authorization 

https://apidocs.callrail.com/#calls

This is what I've attempted to incldue in the Metadata field
{"method":"GET","url":"/calls.json?date_range=today&fields=company_name,first_call,prior_calls,total_calls,campaign,landing_page_url,last_requested_url,utm_campaign,utm_source,utm_medium,utm_term"}

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 16 January 2020

Hello Joshua!

Thank you for contacting us!

 

We will check this API and reply to you back with all the information that is necessary for creating this REST connection as soon as possible.

 

Best regards,

Mariia

0
votes
Joshua Harvey posted this 10 March 2020

Mariia, let me know if you have any updates about the format of the Metadata. I found some articles on the Skyvia Support but not sure which format the GET takes when it comes to the type of operation, this is where I'm lost. I can structure the columns to be retreived for the data structure. 

 

"RetrieveOperation": {

        "UrlSuffix": "",

        "Method": "GET",

        "ReturningStrategy": {

          "Type": "Row"

        },

        "InputType": "JsonBody"

      },

      "RetrieveOperation": {

        "UrlSuffix": "/",

        "Arguments": [

          {

            "ColumnName": "Id",

            "ParameterName": "contact_id",

            "ParameterType": "UrlPath"

          }

        ],

        "Method": "GET",

        "ReturningStrategy": {

          "Type": "Row"

        },

        "InputType": "JsonBody"

      },

      "DeleteOperation": {

        "UrlSuffix": "/",

        "Arguments": [

          {

            "ColumnName": "Id",

            "ParameterName": "contact_id",

            "ParameterType": "UrlPath"

          }

        ],

        "Method": "DELETE"

      }

    }

  ]

 

I was working from this but again not sure how to update the "InsertOperation" and "DeleteOperation" with a "RetrieveOperatoin" of some sort. What is proper syntax for GET requests? 

"Metadata": [ { "Name""Contact""Url""/Contacts""ResultPath""""Columns": [ { "Name""Id""APIPath""Id""DbType""Int32""Primary"true"Createable"false"Updateable"false }, { "Name""FirstName""APIPath""FirstName""DbType""String""Required"false }, { "Name""LastName""APIPath""LastName""DbType""String""Required"true }, { "Name""Email""APIPath""Email""DbType""String""Required"true }, { "Name""Phone""APIPath""Phone""DbType""String""Required"true }, { "Name""UpdatedDate""APIPath""UpdatedDate""DbType""DateTime""Required"false }, { "Name""IsActive""APIPath""IsActive""DbType""Boolean""Required"false }, { "Name""CreatedDate""APIPath""CreatedDate""DbType""DateTime""Required"false } ], "InsertOperation": { "UrlSuffix""""Method""POST""ReturningStrategy": { "Type""Row" }, "InputType""JsonBody" }, "UpdateOperation": { "UrlSuffix""/<contactid>""Arguments": [ { "ColumnName""Id""ParameterName""contactid", "ParameterType""UrlPath" } ], "Method""PUT""ReturningStrategy": { "Type""Row" }, "InputType""JsonBody" }, "DeleteOperation": { "UrlSuffix""/<contactid>""Arguments": [ { "ColumnName""Id""ParameterName""contactid", "ParameterType""UrlPath" } ], "Method""DELETE" } } ] }

0
votes
Mariia Zaharova posted this 11 March 2020

Hello Joshua!

 

Thank you for these details.

I will send you the results in a few days.

 

Best regards,

Mariia

0
votes
Mariia Zaharova posted this 23 March 2020

 Hello Joshua!

 

 

Sorry for the delayed response.

We have sent you all the details by email. Please check it.

 

Best regards,

Mariia

Close