Skip to main content
rodrigoe0001
rodrigoe0001
October 6, 2021
Solved

BigQuery connection not retrieving rows from response

  • October 6, 2021
  • 9 replies
  • 0 views

Hello people! 

I am trying to find a way to connect data from a BigQuery table I have, I found a potential way to do it: By using its API. 

I was able to connect correctly, using a service account , when I then create the integration and I test the connection, I do get the response with 

  • kind"bigquery#tableDataList"(Text)
    • etag"sU8HN6M/RRhXMIrmq4pJgfrw=="(Text)
      • totalRows "5444" 
      • (And I also get this ) rowsList of Dictionary - 5,444 items

      So, as you see the response brings the rows on it, but then when I go to the data source, it does not show me the rows, only kind, etag and totalrows columns, any idea on how to create the table based on the response I get?

        Best answer by peter.lewis

        Yes that's correct - once you create that expression rule, it should return the list of all the data from the integration. So then it's up to you how you want to use it - you could use a grid (see this tutorial: docs.appian.com/.../Grid_Tutorial.html) using the results of your rule.

        9 replies

        peter.lewis
        peter.lewis
        Employee
        October 6, 2021

        So are you trying to create a record type with this integrationas the source? Usually the best way to do that is to use dot notation to index into the rowsList varaiable. Usually, I see this done by creating a separate expression rule and then using the expression rule to format your results. You should be able to return the total rows data like this:

        rule!SAMPLE_YourIntegrationRuleName().totalRows

          rodrigoe0001
          rodrigoe0001Author
          October 6, 2021

          Hello, yes what I want in the end, is to show the rows coming on the JSON response , as a table on Appian

          With the code you ageve me, I guess I need to create a new expression rule , and it may look like this 

          rule!SAMPLE_TGSU_bigquery().totalRows

          am I right?

          peter.lewis
          peter.lewisAnswer
          Employee
          October 6, 2021

          Yes that's correct - once you create that expression rule, it should return the list of all the data from the integration. So then it's up to you how you want to use it - you could use a grid (see this tutorial: docs.appian.com/.../Grid_Tutorial.html) using the results of your rule.

            Terms & ConditionsAccessibility statement