Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Use an HTTP POST call to this endpoint with some JSON

Ahmed
7 - Meteor

Hello , 

 

I try to update my data with a api hubspot

 

I have a URL : 

https://api.hubapi.com/contacts/v1/contact/vid/2340324/profile?hapikey=demo

 

 

I need to pass in parameters this examples :

  "properties": [
    {
      "property": "email",
      "value": "new-email@hubspot.com"
    },
    {
      "property": "firstname",
      "value": "Updated"
    },
    {
      "property": "lastname",
      "value": "Record"
    },
    {
      "property": "website",
      "value": "http://updated.example.com"
    },
    {
      "property": "lifecyclestage",
      "value": "customer"
    }
  ]
  

 On the first i use donwload connectors but after i'dont know what to do.

 

Regards

8 REPLIES 8
Kanderson
10 - Fireball

Ahmed, to post to an API end point you can use the build JSON tool to create the parameter string from a data table. I shared an example of how this can be done with Slack on the portland usergroup site. The workflow at the below link will build a JSON string and with it create a post in a slack channel. We call it our Alteryx bot. 

 

https://community.alteryx.com/t5/Portland-ME/Meeting-2-in-the-books/gpm-p/32526#M14

 

As it happens I have been working a lot lately with reading from the hubspot API, if you continue to run into issues let me know. We should be able to adapt the above workflow to post to hubspot as the process is nearly the same.

Ahmed
7 - Meteor

Thanks,

 

I will come back when you i wil try 

 

Have a nice days

Ahmed
7 - Meteor

Hello

 

Kanderson, i try your solution but i have a issues ,  i posted my workflow : 

 

 

On first like you i define my property and  value , in same  time i enter url  and replace num contact and hapikey:

https://api.hubapi.com/contacts/v1/contact/vid/2340324/profile?hapikey=demo

 My workflow have no error but in downloadData i have message : 

 

{"status":"error","message":"Json node is missing child properties","correlationId":"937b3383-0518-41df-a21f-1552115bca30","requestId":"e076ebedf47004802daf913353e123d3"}

 

Regards

Ahmed
7 - Meteor

Thx it is resolved

Kanderson
10 - Fireball

Glad to hear, I hit that error as well when I built the JSON as "name"/"value" pairs. Let me know if you have any other problems while working with the hubspot api, I am just finishing up some working examples myself.

rashmi
5 - Atom

Hello,

 

I am facing same issue, my workflow have no error but in downloadData i have message :

 

{"errors":[{"code":"DevTokenMissing","description":"DeveloperToken is missing."}],"trackingId":"6af5e3d4-8327-4e14-90b2-bb2c2f6de6c8"}

 

Would you please share that how to resolve it.

 

Regards

Ahmed
7 - Meteor
Hi rashmi,

You have generate a hapikey ?, you can write your URL for call l'API ?
Maybe you don't have a tokken hubspot ?
Prajakta_123
5 - Atom

How it is solved Please provide solution

Labels