BigQuery to Pipefy using Make (Integromat)

  • 13 June 2023
  • 2 replies
  • 157 views

Userlevel 2
Badge

Hi,

 

I’m trying to create a simple pipefy card  using Make.

 

My source is a schema allocated in BigQuery. 

 

I’m writing a SQL, and using a Iterator in array of Rows, and trying to create a card with only one single field but a get the same erro every attempt.

 

INPUT

  • Bundle 1Collection

    • Mode

      organizatioPipeCardPhase

    • Title

      XXXXXXXXXXXXXXXXX

    • Pipe

      303337319

    • AssigneesArray

      • 1

        9999999999

    • Card fieldsArray

      • 1Collection

        • Field

          raz_o_social

        • New value

          XXXXXXXXXXXXXX

    • Organization

      999999999999

    • Start form fieldsArray

      • 1Collection

        • Field

          raz_o_social

        • New value

          XXXXXXXXXXXXX

HANDLED ERROR

  • type

    RuntimeError

  • message

    Error Something went wrong

 

I've succeed in a few attempts, but i really don't know why. Anyone can help me through this initial journey ?

 

Thanks


2 replies

Userlevel 7
Badge +12

Try to isolate things. Is the authentication with Pipefy working, can you e.g. query for cards?

Usually, this error comes when the query you give is wrong, e.g. by having unclosed brackets or “

Could you share some more info, e.g. show your workflow, the actual query you do, the actual code you use?

Userlevel 2
Badge

Thank’s for response. Yes, I did a litle test getting a list of my card inside a pipeline and worked fine.

 

I’m trying now includ a card in a pipefy template Pipeline (Gerenciamento de Churn)

For me, the map between my source and the template fields it’s ok.

 

I’ll send a print of my pipeline and I’ll print here the input afetr the played.

 

 

[
    {
        "mode": "organizatioPipeCardPhase",
        "title": "MURILO DE SOUZA BASTOS ALIMENTOS - ME",
        "pipelineId": "303331065",
        "assigneeIds": [
            "302559556"
        ],
        "main_fields": [
            {
                "field_id": "nome_do_cliente",
                "field_value": "MXXXXXXXXXXXXXXXXXXXXXXXXX- ME"
            },
            {
                "field_id": "email_do_cliente",
                "field_value": "xxxxxxx@xxxxxxx.com.br"
            },
            {
                "field_id": "valor_do_contrato",
                "field_value": "1000"
            }
        ],
        "organizationId": "301144005",
        "startform_fields": [
            {
                "field_id": "nome_da_empresa",
                "field_value": "MXXXXXXXXXXXXXXXXXXXXXXXXX- ME"
            },
            {
                "field_id": "nome_da_empresa",
                "field_value": "MXXXXXXXXXXXXXXXXXXXXXXXXX- ME"
            },
            {
                "field_id": "email_do_cliente",
                "field_value": "xxxxxxx@xxxxxxx.com.br"
            },
            {
                "field_id": "telefone_de_contato_do_cliente",
                "field_value": "(XX) XXXXXXXXXX"
            },
            {
                "field_id": "valor_do_contrato",
                "field_value": "1000"
            },
            {
                "field_id": "quantidade_total_de_usu_rios",
                "field_value": "10"
            }
        ]
    }
]

Reply