On Thursday, January 11, 2018 at 6:39:38 AM UTC-5, Rahul wrote:
>
> Thanks! Anthony for guiding me on this. Always #1 for helping us out.
> Now there is one last thing and it may be trivial but can you point me to
> the right direction. I used below notation. This works fine if I have a
> single record
> db.mytable.insert(field1=record['field1'], field2=record[
> 'field2_alt_spelling'], ...)
>
> However, if I have multiple records, it fails with a type error given
> below
> TypeError: string indices must be integers
>
> *Data is in this format - *
> {u'count': 6, u'items': [{u'refund_status': None, u'tax': None, u'entity':
> u'payment', u'currency': u'INR', u'id': u'Tq99121U7', u'captured': False,
> u'fee': None, u'international': False, u'email': u'help...@gmail.com',
> u'status': u'failed', u'amount_refunded': 0, u'description': u'Purchase
> Description', u'order_id': None, u'vpa': None, u'bank': None,
> u'invoice_id': None, u'notes': [], u'card_id': u'311645', u'method':
> u'card', u'wallet': None, u'amount': 100, u'contact': u'7001394',
> u'error_description': u'Payment failed', u'error_code':
> u'BAD_REQUEST_ERROR', u'created_at': 15138345825},
> {u'refund_status': ......},
> {u'refund_status': None, .... 1513940199} ,
> {u'refund_status': None, u'created_at': 1513738859},
>
Hard to say what the problem is without seeing your code, but your records
are a list embedded in a dictionary, so you need to extract the list and
loop over it:
for record in data['items']:
db.mytable.insert(field1=record['field1'], ...)
Anthony
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
